select max(sal) from employee where sal<(select sal from employee);

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

Question Posted / baburav zore

Answer Posted / baburav zore

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is rownum?

976

What are the three pl sql block types?

1005

which types of join is used in sql widely? : Sql dba

978

What is db journal file?

1055

Why are indexes and views important to an organization?

950

explain the difference between bool, tinyint and bit. : Sql dba

992

Why do we use joins?

1033

Why do we need a foreign key?

1088

Why we use pl sql?

955

What can I use instead of union in sql?

963

Does inner join return duplicate rows?

974

How do I view a sql database?

1016

How do you update a table in sql?

983

What is sql injection owasp?

1058

What is java sql connection?

1046