How to select the name of employee who is getting maximum
sal with out using subquery
Answer Posted / mk
select Name from emp where sal=(select distinct(Max(sal))
from emp
| Is This Answer Correct ? | 4 Yes | 14 No |
Post New Answer View All Answers
How to sort the query output in oracle?
Explain implicit cursor.
How do I spool in oracle?
What is a schema in oracle?
What are the predefined tablespaces in a database?
What are named parameters?
please explain.. DB architecture ...
what is the difference between data migration and production migration.
How many memory layers are in the oracle shared pool?
What is format trigger?
I am using an Oracle 8i Database my data contains Clob data. I am using toad version 7.6 i am able to get the data in toad but unable to extract the data in excel.when trying to extract the data into the excel the toad error says out of memory. Can any body please help me to extract the data through the same toad version. Thanks in advance
What are the various types of snapshots ?
what is the dual table in oracle?
what is insert all statement in sql
What do you mean by a database transaction & what all tcl statements are available in oracle?