Interested to Buy Any Domain ? << Click Here >> for more details...
can anybody tell us, how to select 2nd max salary from
table.
my id is ashish.akk@gmail.com
- 28 Answers
- 32719 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
How to filter records of table in SQL SERVER?
Suppose you want to implement the one-to-one relationships while designing tables. How would you do it?
What do you understand by intent locks?
Define union, union all, minus, intersect?
Can a table be created inside a trigger?
What command would you use to add a column to a table in sql server?
Can you pass expressions to stored procedure parameters?
What will be the maximum number of indexes per table?
What is a not null constraint?
Can a rule be bound to any column of any data type?
What are the advantages of using cte?
What is sub-query in sql server? Explain its properties.
How to update muliple row in single query?
What is normalization of database? What are its benefits?
Describe how to use linked server?
