To find second largest salary in Employee table
Answer Posted / mohammad murtuza ali
select salary from employeetable where empsal is < max(salary)
Is This Answer Correct ? | 4 Yes | 4 No |
Post New Answer View All Answers
What is table level trigger?
Differentiate between SQL and ORACLE joins and write their syntax.
What is the difference between dropping a database and taking a database offline?
What is b tree index?
How do I debug a stored procedure in sql server?
What is the server name in sql server?
What is the most common type of join?
can an automatic recovery be initiated by a user? : Sql server administration
What is built-in/administrator?
How to declare a cursor with "declare ... Cursor" in ms sql server?
What is partitioned view?
What is global temp table?
How do you migrate data from mssql server to azure?
What happens if null values are involved in string operations?
What is a database in ms sql server?