1,描述每一个部门的每个工种的工资最大值(分组统计)
select dept_id,job_cat,max(salary) from employees group by dept_id,job_cat;
2,找出表ppp里面mum是最小的值的一条记录
select top 1 mum from ppp order by mum
select * from ppp where mum=(select Min(mum) from ppp)
3,复制表
select * into new from old where 1=0
select * into new from old
4,在数据表A中,有一个字段LASTUPDATETIME,是最后更新的时间,如果要查最新更新的时间,如何写SQL语句
select * from A where LASTUPDATETIME=(select Max(LASTUPDATETIME)from A)
5,日期字符串转换函数to_char(),to_date()
select to_char(sysdate,'hh:mi:ss')from dual;
select to_date('20080229132545','yyyy-mm-dd hh24:mi:ss')from dual