SELECT MAX(Sal) FROM EMP WHERE Sal < (SELECT MAX(Sal) FRO

how to find the second highest salary from emp table?

Question Posted / subrat

Answer Posted / subrat

SELECT MAX(Sal) FROM EMP WHERE Sal < (SELECT MAX(Sal) FROM EMP)

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How do I find sql profiler?

992

What are different types of triggers?

1186

what is meant by nl2br()? : Sql dba

1107

Is and as keyword in pl sql?

1014

What are the built in functions of sql?

1095

How many types of triggers exist in pl/sql?

1137

how many groups of data types? : Sql dba

1078

how would you get the current date in mysql? : Sql dba

1017

how to escape special characters in sql statements? : Sql dba

1083

Why commit is not used in triggers?

1091

What is a sql driver?

1041

What are conditional predicates?

1128

What normalization means?

1017

How to get help at the sql prompt?

1166

what is single byte over head in oracle..?

2457