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
Tell me what are the essential components of sql server service broker?
How to create a simple user defined function in ms sql server?
How to compose an inquiry to demonstrate the points of interest of an understudy from students table whose name begins with k?
List out what other servers you can use with ssrs?
How to insert data with null values?
How do you delete a data source?
What is the optimization being performed in oracle and SQL Server?
How to include text values in sql statements?
What is the benefit of normalization?
What are .mdf files?
Types of Authentications in Sql Server? How user gets authenticated through windows authentication?
Do you know what are acid properties?
How check triggers in sql server?
How many databases can we create in a single server?
How adventureworkslt tables are related?