Write a query to get all details of employee who has maximum
salary from employee table
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 the types of subscriptions in SQL Server replication?
What is CTE in SQL
Why should you use or avoid select * statements?
Explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?
Why are you getting errors when creating a new odbc dsn?
Explain what are the restrictions that views have to follow? : SQL Server Architecture
If you are given access to a SQL Server, how do you find if the SQL Instance is a named instance or a default instance?
What is row_number () and partition by in sql server?
Why does sql studio use a single registered database repository? : sql server management studio
Does transparent data encryption provide encryption when transmitting data across the network?
What is the difference between composite index and covering index?
What are the differences between stored procedure and view in sql server?
Why use stored procedures in sql server?
Can I disable or restrict ssrs export formats (rendering formats)?
Tell me about normalization in DBMS.