Select sal from emp order by desc fetch first 3 rows only;

a query to select maxmun 3 salaries of employee table

Question Posted / chaitanya

Answer Posted / chaitanya

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is define in oracle?

1065

What is coalesce function?

1079

How to filter out duplications in the returning rows using oracle?

1020

How to create an initialization parameter file?

1060

How do I call oracle stored procedures that take no parameters?

1126

How to load data through external tables?

1144

How do I use unicode codesets with the weblogic jdriver for oracle driver?

1083

What are the advantages of oracle 12c?

1183

What is PL/SQL ?

2083

How to sort output in descending order in oracle?

1052

What are the differences between interval year to month and interval day to second?

1032

What is oracle analytical function?

1156

Explain joins in oracle?

1043

How do you get nicely formatted results from an oracle procedure that returns a reference cursor?

1086

What are set operators?

1091