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
- 17052 Views
- AON, Genpact, I also Faced
- E-Mail Answers
Answer Posted / sureshramsing
select * from emp where (empno,1)=(select * from(select empno,row_number() over(order by sal desc) rn from emp) where rn=1);
| Is This Answer Correct ? | 0 Yes | 4 No |
Post New Answer View All Answers
What are different types of views?
Call by value and call by reference in procedure and function, with NOCOPY.
How to get a list of all tables with "sys.tables" view in ms sql server?
How do you migrate data from mssql server to azure?
Explain the various types of concurrency problem. I.e. Lost or buried updates, uncommitted dependency, inconsistent analysis, phantom read?
Can I run multiple instances of sql server 2000 at the same time on one computer?
What are extended events in sql server?
How can I know what locks are running on which resource?
Can we do dml on views?
How to check if a table is being used in sql server?
Define Unique Key?
How to create a view and a stored procedure in ms sql server using "create view/procedure" statements?
What is the data type of time?
role of sql sever 2005 in database rather than any other database
Every night you run a full backup after every 3 three hours you make a differential backup every hour you make an incremental backup in a worst-case scenario, how much work you can lose?
