Select max(Sal) from emp Where Sal < (Select max(Sal) from emp);

To find second largest salary in Employee table

Question Posted / anu

17 Answers
20866 Views
CSS, I also Faced
E-Mail Answers

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

Please Help Members By Posting Answers For Below Questions

What do you understand by a stored procedure?

1153

Explain syntax for viewing, dropping and disabling triggers?

998

What is the difference between row_number and dense_rank?

936

What factors you will consider calculating the storage requirement for that view?

994

How to disable stored procedure sql server?

1671

What is explicit mode in sql server?

1110

How to execute multiple stored procedures at one time in sql server?

1067

What is difference between clustered and non clustered index?

1035

What do you mean by data manipulation language?

1063

Explain the flow of creating a cube? : sql server analysis services, ssas

1102

Write a sql query to delete duplicate records from a table called table1

1088

What the different types of Replication and why are they used?

1133

How to create a large table with random data for index testing in ms sql server?

1071

What is the language structure to add a record to a table?

1077

Hi, I Created 3 Tables Person(PersID[prkey],Name,Email,Password), Project(ProjName,ProjID[prkey],ProjLeader,ProjManager) & ProjectInvolvement(EntryDate,ProjID[frkey],PersID[frkey],ProjDuration). For this how can i INSERT,UPDATE & DELETE Through PROCEDURE? Please Post the Answer for me. Desai.

1897