how to get second highest salary in SQL(as/4000
- 29 Answers
- 25511 Views
- iGate, I also Faced
- E-Mail Answers
Answer Posted / sachin
select max(sal) from employees
where salary < (select max(sal) from employees);
| Is This Answer Correct ? | 19 Yes | 3 No |
Post New Answer View All Answers
Why do we go for stored procedures?
Does user triggers have entry for trigger with compilation errors?
How can I see all tables in sql?
Explain what is rdbms?
Is truncate ddl or dml?
What are different joins used in sql?
What are types of joins?
what does it mean to have quoted_identifier on? What are the implications of having it off? : Sql dba
Is primary key is clustered index?
what is the syntax used for partition in tsql? : Transact sql
What type of join is sql join?
What is a left inner join?
What is a trigger in sql?
Which certification is best for sql?
What is the life of an sql statement?
