摘要:
//结构:select 子句 [into 子句] from 子句 [where 子句] [group by 子句] [having 子句] [order by 子句]select dept_code,count(*) from oh_corp_infowhere create_date>'2006-01-01' group by dept_code having count(dept_code)>1 order by dept_code//查询前百分之N的数据select top 10 percent * from oh_corp_info//查询语句between 阅读全文