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
- 5596 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
How can you log an error to the server event log from a stored procedure?
How to customize error conditions.
Which data type cannot be used as a parameter in a udf?
What are the types of database model?
How can I detect whether a given connection is blocked?
What is normalization? Explain different levels of normalization?
I have a few records all are same structures data, I want to store data in multiple targets how
In which database can extended stored procedures be added?
How long can an error message be in raiseerror function?
When installing the datastage7.5x2 edtion iam getting aproblem i.e the cpu count is 2 but the cpu count in installation is one . how can i install in my p.c (system is dual core).
Why does this query return 0?
How to combine two function together?
How to use timestamp datatypes
What are the 18 schemas?
What are the three types of database design?
