Sunday, December 10, 2006

SELECT DISTINCT LEFT(日期,7) FROM pzls WHERE 审核标志='是' AND 记账标志='是' AND 是否作废='否'

DISTINCT 不显示重复的数据项，只显示不同的
LEFT（expression,n）从字符串的左边取n个字符

Labels: ,


# posted by 孙志海宁 : 11:23 AM
Comments: Post a Comment



<< Home

This page is powered by Blogger. Isn't yours?