can anybody tell us, how to select 2nd max salary from
table.
my id is ashish.akk@gmail.com
- 28 Answers
- 34123 Views
- IBM, Symphony, I also Faced
- E-Mail Answers
Answer Posted / tulasi ravi kumar
hi,
my id is ravi106109@gmail.com
select sal from emp a
where 1=(select count(b.sal) from emp b
where a.sal<b.sal) order by sal desc;
and also dileep is write
| Is This Answer Correct ? | 3 Yes | 3 No |
Post New Answer View All Answers
What is the primary use of the model database?
What are wait types?
What are the properties of the transaction?
Can you index views?
What is temporary table in sql server? Why we use temp table?
Does view occupy space?
When should you use an instead of trigger?
How do I find query history in sql server?
What is acid mean in sql server?
What is a view in sql?
List out the different types of locks available in sql server?
what is the difference between openrowset and openquery?
What is a coalesce function?
How can I check that whether automatic statistic update is enabled or not?
How do I start sql server 2017?
