how to find the second highest salary from emp table?
- 211 Answers
- 322024 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 / nevin
select min(salary) from (select top 2 sal from table_name order by sal desc)salary
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what are the advantages a stored procedure? : Sql dba
What are different types of sql?
what is index? : Sql dba
What is synchronized subquery?
Explain what is a database?
What is sql not null constraint?
How many commands are there in sql?
How many postgresql users are there, worldwide?
What is microsoft t sql?
What is sqlca in powerbuilder?
How do I run a sql query in pgadmin 4?
Is delete faster than truncate?
Difference between truncate, delete and drop commands?
how to see the create table statement of an existing table? : Sql dba
Why is the cursor important?
