can anybody tell us, how to select 2nd max salary from
table.
my id is ashish.akk@gmail.com
Answer Posted / arun ashok
Select max(salary) from employee where salary not in (select
max(salary) from employee)
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
Do you know what is bit data type and whats the information that can be stored inside a bit column?
What is the difference between migration and upgradation in sql server?
What is collation sensitivity?
How many cores do I need for sql server 2016?
What do you understand by integration services in sql server?
How to use copy and concatenate commands in SQL?
What is BCP? When does it used in sql server 2012?
How to list all triggers in the database with sys.triggers in ms sql server?
What is view in sql?
What is self contained scalar sub query?
How many replicas are maintained for each sql azure db?
Can you always create a cache of a report?
What is the user of Primary key?
what is a default tcp/ip socket assigned for sql server? : Sql server database administration
How to locate and take substrings with charindex() and substring() functions?