can anybody tell us, how to select 2nd max salary from
table.
my id is ashish.akk@gmail.com
Answer Posted / mahesh
Select max(sal) from emp
where id='1233' and Sal< (select max(sal) from emp)
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
role of sql sever 2005 in database rather than any other database
What is the maximum number of instances in 32 bit and 64 bit sql server 2012?
How to select some specific rows from a table in ms sql server?
What does it mean to be in union?
Explain Geography datatype in SQL Server
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? : Sql server administration
List the various tools available for performance tuning?
What is the web service used for reporting services?
How to insert and update data into a table with "insert" and "update" statements?
What is the difference between for auto and for nested?
Explain insert into select statement?
Explain indexed views and partitioned view with their syntax.
What are the parts of a function?
How to create a login account in ms sql server to access the database engine using "create login" statements?
What is replication and database mirroring?