Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the first two highest salaries in deptno in emp
table
- 2 Answers
- 5697 Views
- I also Faced
- E-Mail Answers
Answer Posted / ajitnayak
select e.*
from emp e
where rownum < 3
order by e.sal desc ;
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is normalization? Explain different levels of normalization?
Why does this query return 0?
In which table collections errors are stored.
What you can do to remove data from the cache and query plans from memory for testing the performance of a query repeatedly?
How to customize error conditions.
What are the key features of dbms?
What are the three basic rules which are to be followed for the relational model of the database?
Explain about relational database management systems?
How you can make a parameterized view?
On friday, you issued several insert statements using query analyzer. You then verified the data had been correctly entered with a select statement on monday, your users report that the data is not there what happened?
Explain about network model?
Explain about normal forms?
Explain about xml databases?
Explain the role of indexing in databases?
How long can an error message be in raiseerror function?
