can anybody tell us, how to select 2nd max salary from
table.
my id is ashish.akk@gmail.com
- 28 Answers
- 34159 Views
- IBM, Symphony, I also Faced
- E-Mail Answers
Answer Posted / swapnl
select max(sal) from emp_det where sal not in (
select max(sal) from emp_det);
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
Can we do dml on views?
How can we solve concurrency problems?
How can I check that whether automatic statistic update is enabled or not?
How do I start sql server 2017?
How to remove duplicate rows from table except one?
If any stored procedure is encrypted, then can we see its definition in activity monitor?
How efficient you are in oracle and SQL server?
do you know how to configure db2 side of the application? : Sql server database administration
Can one drop a column from a table?
How raid can influence database performance?
How do I create a trace in sql server?
What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?
List the ways in which dynamic sql can be executed?
What are wait types?
What are the pros and cons of putting a scalar function in a queries select list or in the where clause?
