select rownum as rowid,salary from (salary from employees oderby salary

how to calcuate the second highest salary of he employee

Question Posted / sunilpanghal

Answer Posted / sunilpanghal

select rownum as rowid,salary from (salary from employees
oderby salary )where rownum <2

Is This Answer Correct ?

1 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What is recursive stored procedure?

1103

What is mdb stand for?

1016

What is snowflake sql?

1080

What is procedure and function in sql?

1003

What is difference between stored function and application function?

1212

Explain the difference in execution of triggers and stored procedures?

1026

what is the functionality of the function htmlentities? : Sql dba

972

What is nvarchar in sql?

930

What is the difference between distinct and unique in sql?

957

What found sql?

947

What is the difference between cluster and non-cluster index?

1113

How to avoid using cursors?

1128

Explain the difference between rename and alias?

1021

What are the most important ddl statements in sql?

1126

How do I run a pl sql procedure in sql developer?

981