Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to get all details of employee who has maximum
salary from employee table
- 8 Answers
- 16736 Views
- AON, Genpact, I also Faced
- E-Mail Answers
Answer Posted / sureshramsing
select * from(select e.* from emp e order by sal desc) where rownum=1;
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What is the command used to check locks in microsoft sql server?
what is the difference between count(*) and count(1) ?
What are the differences between web role and worker role?
Explain nested stored procedure. Syntax and an example for create nested stored procedure?
Explain what are magic tables in sql server?
What is resultset concur_updatable?
Tell me what is the stuff and how does it differ from the replace function?
What is the chart in report?
Do you know what is similarity and difference between truncate and delete in sql?
Why is normalisation important?
What is the difference between ‘having’ clause and a ‘where’ clause?
How many clustered indexes there can be on table ?
What is the difference between mysql and mysqli?
Does partitioning ssd reduce performance?
Define clusters?
