Showing posts with label Sql Query Max and Min Salary AND EmpName. Show all posts
Showing posts with label Sql Query Max and Min Salary AND EmpName. Show all posts

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)