Spark-SQL 源代码

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 '[^李]%'

select 光盘编号=gph ,光盘名称=gpmc,光盘语言=gpyy from gpb where gph between 2 and 7

select * from employee where ygbh in ( 2,4,6)