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 do I edit a procedure in sql server?
Stored Procedure returns data from multiple tables. How to access it in your ASP.Net code?
How can you insert values in multiple rows using one Insert statement?
What is onf in normalization form?
Can a synonym name of a table be used instead of a table name in a select statement?
What is an index in a database?
How to create user defined functions with parameters?
Define Unique Key?
What are the restrictions applicable while creating views? : SQL Server Architecture
can you instantiate a com object by using t-sql? : Sql server database administration
Explain external key management in sql server 2008
How the authentication mode can be changed?
How to Sync Two SQL Azure Databases?
What is an identity?
What is the recovery model? List the types of recovery model available in sql server?