You should use rank query with order by and give where your search criteri

how to find the second highest salary from emp table?

Question Posted / barochia dharmesh

Answer Posted / barochia dharmesh

You should use rank query with order by and give where your
search criteria.

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How do you update a sql procedure?

970

Is postgresql a server?

995

When should I use nosql database?

944

What is cursor and why it is required?

1106

What is raw datatype in sql?

980

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

912

what is denormalization. : Sql dba

1042

what is meant by nl2br()? : Sql dba

974

What is an intersect?

1045

How do you write a subquery?

965

How does one load ebcdic data? : aql loader

1093

Is like operator in sql case sensitive?

961

Explain what is dbms?

986

Does sql backup shrink transaction log?

914

what is the use of friend function? : Sql dba

971