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
- 32698 Views
- IBM, Symphony, I also Faced
- E-Mail Answers
Answer Posted / selvaraj.v
In SQL Server 2000 Query:
-------------------------
select max(salary) from Employee where salary not in(select
max(salary) from employee)
This Query only selects the 2'nd Higehest Salary in that
table. So, you will try...
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Do you know exporting and importing utility?
What are the types of subscriptions in SQL Server replication?
What is an execution plan?
What is the datatype of rowid?
how can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A
How to declare a cursor with "declare ... Cursor" in ms sql server?
According to you what goes into making the best database administrator? : sql server database administration
Define constraints and give an example of their use?
Can a cursor be updated? If yes, how you can protect which columns are updated?
What are the types of indexes?
What is user defined stored procedures?
Mention the different types of replication in sql server.
Explain different types of index?
what are the different types of replication you can set up in sql server? : Sql server database administration
What is a natural primary key?
