Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 361219 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 / vikas
select top 1 salary from emp
where salary in (select top 2 salary from emp order by salary desc)order by salary
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the size of partition table?
How to check if a column is nullable before setting to nullable?
What is sql performance tuning?
how to show all tables with 'mysql'? : Sql dba
How do I run a script in sql developer?
Which column of the user triggers data dictionary view displays the database event that will fire the trigger?
Is it important to partition hard disk?
Why do we need sharding?
Can there be 2 primary keys in a table?
Mention what does plvtab enables you to do when you showthe contents of pl/sql tables?
what are ddl statements in mysql? : Sql dba
what is the difference between $message and $$message? : Sql dba
What are different joins used in sql?
How do I view a procedure in sql?
what is a primary key? : Sql dba
