How to read 2nd highest sal from EMP table?
Answer Posted / sasikala
select max(salary) from emp where salary<(select max(salary) from emp);
| Is This Answer Correct ? | 11 Yes | 0 No |
Post New Answer View All Answers
Can we call future method from queueable?
Explain few of the new features of sql server 2008 management studio
How do you manipulate data?
How to access the inserted record of an event?
what are the different ways to return the rowcount of a table?
What are the different types of sub-queries?
Can I work with several databases simultaneously? : sql server management studio
What is row_number () and partition by in sql server?
Explain what is “asynchronous” communication in sql server service broker?
When to use null data driven subscription?
What is the difference between online clustering and Offline clustering?
Why can there be only one clustered index and not more than one?
What are the different types of locks in the database?
What are the types of stored procedures in an sql server?
Explain the properties of the relational tables?