SELECT TOP (3)with ties empsalry FROM empsalr order by emp

a query to select maxmun 3 salaries of employee table

Question Posted / kumari

Answer Posted / kumari

SELECT TOP (3)with ties empsalry
FROM empsalr

order by empsalry desc;

Is This Answer Correct ?

1 Yes

4 No

Please Help Members By Posting Answers For Below Questions

what is the scenario where you take the database to NoArchivelog mode?

2259

21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.

2046

What is the difference between "as" and "is" in an oracle stored procedure?

935

What is difference between sid and service name in oracle?

906

What are the ansi data types supported in oracle?

898

Please explain drop constraint oracle?

1029

What is set verify off in oracle?

1034

Explain the use of owner option in exp command.

994

When do you get a .pll extension in oracle?

1078

How do I limit the number of rows returned by an oracle query after ordering?

1102

How to load data through external tables?

1074

How to list all indexes in your schema?

1034

Explain what are synonyms used for?

983

Why is oracle database so popular?

949

How to use regular expression in pattern match conditions in oracle?

977