Write a query to get a list of employees from an employee table who lives in delhi stored by names
Answers
Answered by
1
create table ee (eno int, ename varchar(200), sal int)
insert into ee values(1, 'a', 2000)
insert into ee values(2, 'b', 6000)
insert into ee values(3, 'c', 8000)
select ENO, ENAME, min(sal) AS SAL from ee group by eno,ename having min(sal) > 5000
insert into ee values(1, 'a', 2000)
insert into ee values(2, 'b', 6000)
insert into ee values(3, 'c', 8000)
select ENO, ENAME, min(sal) AS SAL from ee group by eno,ename having min(sal) > 5000
Similar questions