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
What is DB Development software?
explain detail about ftp in datastage?
What are the key features of dbms?
How you can make a parameterized view?
You have two tables with a one to many join based on a field named id. You need to find records in the parent table that are not represented in the child table. how would you accomplish this?
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).
Explain about post-relational databases?
Explain the role of indexing in databases?
What is the maximum length of an extended property?
How long can an error message be in raiseerror function?
Who are naive users?
Explain about relational database management systems?
How to generate OIDS
How is data stored in dbms?
What is data modeling with example?