select max(salary) from emp where salary<(select max(salary) from emp);

How to read 2nd highest sal from EMP table?

Question Posted / sasikala

Answer Posted / sasikala

Is This Answer Correct ?

11 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Explain what are page splits? : SQL Server Architecture

1070

What are the advantages of user defined function?

986

What is the difference between a "where" clause and a "having" clause?

1160

How to recreate an existing index in ms sql server?

1059

Write a query for primary key constraint with identity key word?

1031

What is the maximum size per database for sql server express?

1058

What is sql service broker?

987

what is a check constraint?

1126

What is the impact on other user sessions when creating indexes?

927

What are commonly used odbc functions in php?

1015

What are the different types of locks in the database?

925

Introduction of rollup clause using sum and group by clause?

968

sql database suspect We have a sql database that is showing as suspect. How can we recover?

1936

Why variables called the most powerful component of ssis?

1082

Can we linked SharePoint to a SQL database?

1031