MySql数据库中Select用法小结

'sql = "Select * from [sheet1$] Where 出库日期 between #2005-1-4# and #2005-1-10# and 销售单价>100"

'sql = "Select * from [sheet1$] Where 物品名称 like '%扶手%'"

'sr = "挡泥板"
'sql = "Select * from [sheet1$] Where 物品名称 ='" & sr & "'"

'sql = "Select * from [sheet1$] Where 物品名称 in('车衣','扶手箱')"

'sql = "Select * from [sheet1$] Where left(物品代码,3)='028'"

'sql = "Select * from ChuKu"

'sql = "Select """",出库日期,"""",物品代码,"""",规格,单位 from ChuKu"

'sql = "Select Distinct """",物品代码 from ChuKu"

'sql = "Select top 30 Percent * from ChuKu"

'sql = "Select ID,Format(出库日期,""yyyy-mm-dd"") from ChuKu"

'sql = "Select * from ChuKu Order by 出库日期 asc,销售单价 desc"
'sql = "Select Top 10 * from ChuKu Order by 出库日期 asc,销售单价 desc" '筛选销售数量前10()

'sql = "Select """","""",物品代码,"""","""","""",sum(出库数量) from ChuKu group by 物品代码" ' 跳过的用""""

'sql = "Select """","""",物品代码,"""","""","""",sum(出库数量) from ChuKu group by 物品代码 HAVING sum(出库数量)>=3"