liukun2009 发表于 2018-9-22 13:29:04

Oracle练习

　　select (select max(s_salary) from salary where depid=1)
　　,(select max(s_salary) from salary where depid=2)
　　,(select max(s_salary) from salary where depid=3)
　　,(select max(s_salary) from salary where depid=4)
　　from dual

页: [1]
查看完整版本: Oracle练习