To find second largest salary in Employee table
Answer Posted / anu
Select max(Sal) from emp
Where
Sal
<
(Select max(Sal) from emp);
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is user defined datatypes and when you should go for them?
What the different types of Replication and why are they used?
Why we use the openxml clause?
How to delete a database in ms sql server?
why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it? : Sql server administration
How can a database be repaired?
You are designing a strategy for synchronizing an SQL Azure database and multiple remote Microsoft SQL Server 2008 databases. The SQL Azure database contains many tables that have circular foreign key relationships?
What is a trigger in sql server?
What is the size of transaction log file?
What are drillthrough reports?
Some queries related to SQL
Difference between LEN() and DATALENGTH() in sql server ?
What is ms sql server index?
What are data resources?
What do you mean by cardinality?