To find second largest salary in Employee table
Answer Posted / chitharthan
select max(salary)-1 from employeetable
| Is This Answer Correct ? | 0 Yes | 10 No |
Post New Answer View All Answers
What is @@error in sql?
What is function of master database?
What is the difference between grant and with grant while giving permissions to the user?
What does null mean?
Define magic tables in sql server?
What are clustered and non-clustered index?
Explain in details security in SQL azure?
How to drop an existing table?
How to configure and test odbc dsn settings?
What stored by the tempdb ? : sql server database administration
Can primary key be a foreign key?
How to insert a new row into a table with "insert into" statements in ms sql server?
Tell me when is the update_statistics command used?
What Are the Main Features of SQL Azure?
What is cursor in ms sql server?