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 is the benefit of normalization?
What is the security principal at the database level that represents your session?
What are the restrictions while creating batches in sql server?
Difference between report and query parameter. Why do we need different type of parameter?
What is dimension table? : sql server analysis services, ssas
What is ssl in sql server?
What is sql collation?
How to automatically create a log when an exception is being received into SQL Server?
What function does a database engine serve in the sql server?
Do you know what is blocking?
What is implicit mode in sql server?
Explain optimistic and pessimistic concurrency?
List the advantages of using stored procedures?
Once setting replication, is it potential to own a publisher as sixty four bit sql server and distributor or subscribers as a thirty two bit sql server?
How to execute a sql statement using odbc_exec()?