select max(salary) from Emp where salary<(select max(salary) from Emp)

Write a query to get 2nd maximum salary in an employee table ?

Question Posted / srinivas

Answer Posted / srinivas

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What are variables in pl sql?

1160

What port does sql server use?

1057

Is it possible to create startup or shutdown trigger for on-schema?

1021

What is an example of translating a date into julian format?

1115

What is ttitle and btitle?

1061

How do I create an index in word?

1027

What is a design view?

920

What pl/sql package consists of?

1076

Where the sql database files are stored?

1014

What are database links used for?

1040

Explain the working of primary key?

1089

What is keys and its types?

1069

What is the main reason behind using an index?

1013

what happens if null values are involved in expressions? : Sql dba

1039

What is the difference between left join and right join?

941