SQL+parser 源代码

select * from ghsb where ghsbh in (select ghsbh from gpb where gpyy='英语')

select convert(char(20),getdate()) as 默认时间, convert(char(20),getdate(),101) as 美国, convert(char(20),getdate(),102) as ANSI se…

select gph as 光盘编号 ,gpmc as 光盘名称,gpyy as 光盘语言 ,gpcd as 光怕光盘产地 ,qnt as 光盘数量 from gpb where qnt

select ygxm , dh,zz from employee where zz like '%交大路%'

select gph as 光盘号 , gpcd as 光盘产地 , qnt as 光盘数量 from gpb where gph < (select gph from gpczb where ygbh=4)

select lower('i LOVE you') as 小写字母 select upper('please reading') as 大写字母 select replicate('go',10) as 复制函数 select reverse('uoy…

select max(gpdj) as 最贵光盘价格, min(gpdj) as 最便宜价格 ,sum(gpdj*qnt) as 总共价值 , avg(gpdj) as 平均价格 from gpb

select * from employee where ygxm like '[^李]%'