SELECT MAX(SAL) FROM TEST_123 WHERE SAL NOT IN (SELECT MAX(SAL) FROM TEST

how to find the second highest salary from emp table?

Question Posted / vinod

211 Answers
367467 Views
CIS, Cognizant, Cosmosoft, DAS, EDS, GreenTech, HOV Services, IBM, Infosys, National Institute of Science and Technology, Patni, Persistent, Polaris, TCS, Wipro, Yardi, Zensar, I also Faced
E-Mail Answers

Answer Posted / vinod

SELECT MAX(SAL) FROM TEST_123 WHERE SAL NOT IN (SELECT
MAX(SAL) FROM TEST_123)

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is sql catalog?

1014

What is the difference between having clause and where clause?

1057

What is multiple columns?

1063

What is trigger types in sql?

989

explain the delete statements in sql

1045

What are the subsets of sql?

1127

What is a common use of group by in sql?

1045

What is case function?

1034

Can we create clustered index without primary key?

962

Can primary key be changed?

903

What is the difference between having and a where in sql?

1099

what is a database? : Sql dba

1162

Write a program that shows the usage of while loop to calculate the average of user entered numbers and entry of more numbers are stopped by entering number 0?

2277

What is an emotional trigger?

1001

What are the basic sql commands?

1086