To find second largest salary in Employee table
Answer Posted / anil
select max(salary) from tbl_employee where salay <(select max(salary) from tbl_employee)
Is This Answer Correct ? | 30 Yes | 6 No |
Post New Answer View All Answers
How to create user defined functions with parameters?
How many triggers you can have on a table?
What are dml (data manipulation language) statements in ms sql server?
What is Federation and Federation Member?
How do we Backup SQL Azure Data?
What are scalar functions?
Which are the olap features?
Which language rdl files made of?
What is the difference between mysql and sql server?
Determine how to use the inserted and deleted pseudo tables?
Delete duplicate rows without using rowid.
Explain what is lock escalation?
How to view the error log for any specific instance? : sql server database administration
What is the sql case statement used for? Explain with an example?
What is autocommit mode in sql server?