-- order by command in SQL
create table Employee1(Empid varchar(255),Ename varchar(255),Ecity varchar(255),Esalary int,Dept_id int);
insert into Employee1(Empid,Ename,Ecity,Esalary,Dept_id)values(101,"Anurag","Delhi",12000,01),(102,"Anshu","Goa",10000,01),(103,"Manav","Goa",15000,02),(104,"Ankur","Delhi",8000,03),(105,"Ankit","Jaipur",8000,03);
-- select * from Employee1;
-- select * from Employee1 order by Esalary DESC; 
-- select sum(Esalary),Ecity from Employee1 Group By Ecity;
-- select sum(Esalary),Ecity from Employee1 Group By Ecity having sum(Esalary)>5000;
create view Employee2 as select Empid,Ename from Employee where city="Delhi"; -- creating a view
-- select * from Employee1;
Drop view Employee2; -- dropping a view name
select max(Esalary) from Employee1;
Select Ename from Employee1 where Esalary = (select max(Esalary) from Employee1);