how to find the first two highest salaries in deptno in emp
table
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
Hi , any one can help me on the same,this is regarding the Informatica Function doc,i want to know how developer is will develop the mapping. pl forwar the any function doc .just for my references. svlc75@yahoo.co.in
Explain the role of indexing in databases?
What is an application role and explain a scenario when you would use one?
How can you log an error to the server event log from a stored procedure?
Who are naive users?
What is DB Development software?
Explain the cube operator?
How to combine two function together?
Which data type cannot be used as a parameter in a udf?
How to replace not in with not exist?
fact table and dimension table containg one to many relationship or many to one relastionship
How you can make a parameterized view?
Why does this query return 0?
What are the constraints on severity level in raiseerror?
Explain about xml databases?