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
Can we shrink data file in sql server?
What is SQL Azure Firewall?
What is indexed view?
You want to use a perspective in an mdx query. How do you select the perspective?
What are ddl triggers and types of ddl trigger?
Which data types generate inaccurate results if used with an = or <> comparison in a where clause of a sql statement?
Can you explain what is the use of custom fields in report?
Do you know how to make remote connection in database?
What is the stuff?
What is the difference between varchar and nvarchar datatypes?
between cast and convert which function would you prefer and why?
What is enhanced database mirroring in sql server 2008?
Do you know what are the properties of the relational tables?
What are various limitations of the views?
What happens if date-only values are provided as date and time literals?