Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to find five highest salaries from EMP table.
(there is a column SALARY)
- 24 Answers
- 50761 Views
- Cap Gemini, iNautix, I also Faced
- E-Mail Answers
Answer Posted / priya
SELECT Rownum,emp-name,salary
FROM(SELECT emp_name,salary
FROM employees
ORDER BY salary Desc)
WHERE Rownum<=5;
| Is This Answer Correct ? | 17 Yes | 3 No |
Post New Answer View All Answers
What are sql constraints?
a table has 2 classifications 1)liabilities 2)earnings this liabitity has 2 elements with 2 input values and the earnings have 2 elements with 2 input values i wrote a query so that my input is liability savings amount1 amount2 xxxx null xxxxxx 0 xxx1 null xxxxx1 0 null yyyy 0 yyyy null yyy1 0 yyy1 my problem is --when i developed a report(d2k) with this data my o/p is liabilities,amount1,savings,amount2 xxxx xxxxxx xxx1 xxxxx1 yyyy yyyy yyy1 yyy1 how could i move this savings,savings values 2 palces up. can any body provide me witha better solution
what is a control file ? : Sql dba
What is the trigger in sql?
can sql servers linked to other servers like oracle? : Sql dba
Name the different types of indexes in sql and define them.
Mention what does the hierarchical profiler does?
Why use triggers in sql?
Which column of the user triggers data dictionary view displays the database event that will fire the trigger?
how to use like conditions? : Sql dba
Where are my tempfiles, I don't see them in v$datafile or dba_data_file?
Which sql statement is used to return only different values?
What is a mutating table and a constraining table?
Is it mandatory for the primary key to be given a value when a new record is inserted?
How can a pl sql block be executed?
