a query to select maxmun 3 salaries of employee table
Answer Posted / kumari
SELECT TOP (3)with ties empsalry
FROM empsalr
order by empsalry desc;
| Is This Answer Correct ? | 1 Yes | 4 No |
Post New Answer View All Answers
what is the scenario where you take the database to NoArchivelog mode?
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.
What is the difference between "as" and "is" in an oracle stored procedure?
What is difference between sid and service name in oracle?
What are the ansi data types supported in oracle?
Please explain drop constraint oracle?
What is set verify off in oracle?
Explain the use of owner option in exp command.
When do you get a .pll extension in oracle?
How do I limit the number of rows returned by an oracle query after ordering?
How to load data through external tables?
How to list all indexes in your schema?
Explain what are synonyms used for?
Why is oracle database so popular?
How to use regular expression in pattern match conditions in oracle?