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 difference between I and G in Oracle?
Explain the use of control file?
How do we get field details of a table?
How do we display rows from the table without duplicates?
Can you tell me how to add new column in existing views?how?How is possible?
Explain about integrity constraint?
What is the difference between formal parameters and actual parameters?
what are steps for interface? where is exchange rate defined in which table?
how to do daily transactions with out sql* loader control file regesterd in apps?
what is meant by magic query
What is the string concatenation operator in oracle?
How to filter out duplications in the returning rows using oracle?
Difference between pre-select and pre-query
How to loop through a cursor variable?
What is literal?