Write a query to get all details of employee who has maximum
salary from employee table
Answer Posted / vineet
Select * from EMP_TAB where salary = (select max(salary) from EMP_TAB;
Is This Answer Correct ? | 8 Yes | 1 No |
Post New Answer View All Answers
How can you find out which stored procedures are recompiling?
What is the difference between DataRow.Delete() and DataRow.Remove()?
Can a stored procedure call itself or recursive stored procedure? How many levels sp nesting is possible?
What is the most common trace flags used with sql server?
What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?
what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration
what method you can use to reduce the overhead of Reporting Services data sources?
as a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this? : Sql server administration
Define inner join in sql server joins?
Explain the dirty pages?
List layers of abstraction microsoft architectured to provide relational db through cloud platform ?
What is clustered vs nonclustered index?
What is SQL Azure?
List the different normalization forms?
How to trouble shoot if unable to connect SQL Server