To find second largest salary in Employee table
Answer Posted / amit
select max(salary) from employee where salary != (select max
(salary) from employee)
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
State the difference between local and global temporary tables?
How to how to convert numeric expression data types using the convert() function??
What is de-normalization in sql database administration? Give examples?
What are approximate numeric data types in ms sql server?
What do you understand by mirroring?
What are differences in between sql server 2012 and sql server 2016?
what changed between the previous version of sql server and the current version? : Sql server database administration
Can we add an identity column to decimal datatype?
what are different types of raid configurations? : Sql server database administration
What are the aggregate and scalar functions?
What are the steps you should follow to start sql server in single-user mode?
Tell me in brief how sql server enhances scalability of the database system?
What is a database in ms sql server?
What does the not null constraint do?
What are the five characteristics of good data?