select * from emp where max(sal) where rownow=2

how to get second highest salary in SQL(as/4000

Question Posted / praveen

Answer Posted / praveen

select * from emp where max(sal)
where rownow=2

Is This Answer Correct ?

0 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What is the use of index in hive?

1002

What are the string functions in sql?

971

How do I upgrade sql?

998

What is the difference between inner join and outer join?

989

Why do we use %rowtype & %type in plsql?

1046

How exception handling is done in advance pl/sql?

979

What are sql data types?

1019

What is information schema in sql?

1068

What is record type in pl sql?

984

how to use 'mysql' to run sql statements? : Sql dba

1051

List the ways to get the count of records in a table?

900

What is an escape character in sql?

1024

Can procedure in package be overloaded?

1081

What is a sql instance vs database?

1112

What does the base_object_type column shows in the user.triggers data dictionary view?

1047