Wednesday, August 6, 2014

Sql Query Max and Min Salary AND EmpName

create table emp1(id int,empname varchar(50),salary int,address varchar(50))

select * from emp1


select empname,salary from emp1 where salary in (select MAX(salary) from emp1)