Write a query to get all details of employee who has maximum
salary from employee table
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
How to add additional conditions in SQL?
What are page splits?
What are the export options of ssrs?
How do I start sql server agent automatically?
Explain what are the restrictions while creating batches in sql server?
A trigger can reference objects outside the current database? State true or false.
What is replication and database mirroring?
What do you understand by triggers and mention the different types of it?
Tell me in brief how sql server enhances scalability of the database system?
What are the different sql server versions?
What is candidate key with example?
How retrieve field names from the table in SQL through JAVA code?
How to change parameter value inside the report?
What are types of storage modes? : sql server analysis services, ssas
How to use copy and concatenate commands in SQL?