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
- 5585 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
Explain about the hierarchical model of the database?
Explain about relational operator join?
Explain the rollup operator?
What is the maximum length of an extended property?
How to combine two function together?
Explain the cube operator?
What is data modeling with example?
What is normalization? Explain different levels of normalization?
Explain about the database management systems.
How to generate OIDS
What are the types of database model?
What are the three types of database design?
How can you fix a poorly performing query?
There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?
Explain about network model?
