Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 367830 Views
- CIS, Cognizant, Cosmosoft, DAS, EDS, GreenTech, HOV Services, IBM, Infosys, National Institute of Science and Technology, Patni, Persistent, Polaris, TCS, Wipro, Yardi, Zensar, I also Faced
- E-Mail Answers
Answer Posted / vinod dubey
select * from emp
where sal = (select max(sal) from emp where sal <>(select max(sal) from emp));
it will defiantly work
best of luck
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How do you declare a variable in pl sql?
What is relationship? How many types of relationship are there?
mention if it is possible to import data directly from t-sql commands without using sql server integration services? If yes, what are the commands? : Transact sql
How to fix oracle error ora-00942: table or view does not exist
what is error ora-03113: end-of-file on communication channel?
What is package in pl sql with an examples?
How many sql statements are used?
How can a function retun more than one value in oracle with proper example?
How do I run a sql query in pgadmin 4?
What is the use of index in sql?
What is the purpose of primary key?
Can we connect to postgresql using sql developer?
How is debugging done?
Can a foreign key be null?
What is a delimiter in sas?
