How to select the name of employee who is getting maximum
sal with out using subquery
Answer Posted / rohit
SELECT ENAME,SAL FROM EMP
WHERE ROWNUM = 1
ORDER BY SAL DESC
| Is This Answer Correct ? | 0 Yes | 7 No |
Post New Answer View All Answers
What is blob datatype?
Are truncate and delete commands same? If so why?
Is it possible to split the print reviewer into more than one region ?
Explain the truncate in oracle?
Differentiate between post-database commit and post-form commit?
what is IDE,DMV in sql server?
Explain do view contain data?
What is transport network substrate (tns) in oracle?
Hi friends can u send the oracle 9i full version download link?????????????? please reply ?
Explain the difference between a procedure and a function? What do you understand by those terms?
Can we write dml statement in function in oracle?
How to view the tablespaces in the current database?
how to make an oracle object
What is program global area (pga) in oracle?
If youre unsure in which script a sys or system-owned object is created, but you know its in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?