How to select the name of employee who is getting maximum
sal with out using subquery
- 15 Answers
- 12119 Views
- I also Faced
- E-Mail Answers
Answer Posted / lince
select top 1 Name from emp order by sal desc
| Is This Answer Correct ? | 8 Yes | 11 No |
Post New Answer View All Answers
What is a Garbage Collection? and what is full recursive Garbage collection?
What is a synonym? What are its various types?
What is the difference between substr & instr functions?
How many types of table in Oracle?
Whether any commands are used for months calculation? If so, what are they?
Difference between varchar and varchar2 data types?
How will you differentiate between varchar & varchar2?
what is the scripts in data base?
A table t is there.If you perform insert ,update and delete then the trigger will fire.What is the minimum no of trigger required for a table.
Can we use oracle pl/sql block in core java? if so how? pls get back to me .....
How can you merge two tables in oracle?
what is the difference between data migration and production migration.
What is a procedure 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?
What are the database administrators utilities available?
