select sal, ename from employee where ROWNUM = 2 order by sal;

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

Question Posted / siddhartha

Answer Posted / siddhartha

select sal, ename from employee where ROWNUM = 2 order by
sal;

Is This Answer Correct ?

12 Yes

36 No

Please Help Members By Posting Answers For Below Questions

Explain architecture of sql server notification services?

989

What is clustered and nonclustered index in sql?

896

what is the difference between clustered and non clustered index in sql? : Sql dba

1050

What is gpt format?

895

Why is stored procedure faster than query?

909

How do you update f as m and m as f from the below table testtable?

1792

What is offset and limit in sql?

1002

What is the sql query to display the current date?

993

Is sql port 1433 encrypted?

974

What is row_number () in sql?

935

What is an escape character in sql?

983

How do you define a foreign key?

941

What does varchar include?

908

Is sql low level language?

963

What is not null in sql?

987