69sql语句.txt

非常适合新手练手的J2EE实战项目

select top 20 * from tb_brand where jc like '%z%' order by id

select * from tb_brand

select min(id) from select * from  tb_brand where jc like '%z%' 

select * from tb_kucun

select * from tb_sell where jc like '%z%' and xsdate between '2003/09/01' and '2003/10/01'

select * from tb_sell where  xsdate between '2003-09-01' and  '2003-10-01'

select *  from tb_sell where xsdate like '%09%'  order by je asc

select spid,sl from tb_sell where xsdate between '2003/09/01' and '2003/09/30' order by sl desc

select * from tb_sell where xsdate between '2003/09/01' and '2003/09/30' order by sl desc

select spid,spname,sum(sl) as sumsl,sum(je) from tb_sell where  xsdate between '2003/09/01' and '2003/09/30' group by spid,spname order by sumsl desc


select * from tb_brand a inner join (select spid,sum(sl) as sl,sum(je) as je
 from tb_sell where  xsdate between '2003/09/01' and '2003/09/30' group by spid ) as b 
 on a.id=b.spid order by sl desc

select count(*) as aa from tb_sell where xsdate between '2003/09/01' and '2003/09/30'group by spid

select spid,sum(sl) as aa from tb_sell where xsdate between '2003/09/01' and '2003/09/30'group by spid

select count * from select spid,sum(sl) as aa from tb_sell where xsdate between '2003/09/01' and '2003/09/30'group by spid

select * select * from tb_brand a inner join (select spid,sum(sl) as sl,sum(je) as je from tb_sell where xsdate between '2003/09/01' and '2003/09/30' group by spid ) as b on a.id=b.spid order by je desc