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
- 32717 Views
- IBM, Symphony, I also Faced
- E-Mail Answers
Answer Posted / dileep.t
If you need the second highest salary only
then following will also work,
select Max(Salary) from TableName
where Salary not in(
Select Max(Salary) from TableName)
| Is This Answer Correct ? | 20 Yes | 3 No |
Post New Answer View All Answers
What are security principals used in sql server 2005?
What is a result set object returned by odbc_exec()?
What is the sql server agent?
What are indexes in sql?
How you can find out if an index is useful to the optimizer?
How to get @@error and @@rowcount at the same time?
Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?
what does the automatic recovery do? : Sql server administration
What is snapshot replication?
How to reaname table name without using sp_Rename in sql server..?
What is CTE in SQL
Are null values the same as that of zero or a blank space?
plss anybody specify tha constrian management system in dbms
What are the requirements to use odbc connections in php scripts?
You notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it?
