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
You want to use a perspective in an mdx query. How do you select the perspective?
What is a Join and explain its types?
When does the auto update index statistics feature in sql server turn itself on?q) what specific conditions database should meet, before you can bulk copy data into it using bcp?
what are statistics, under what circumstances they go out of date, how do you update them? : Sql server database administration
What is the default fill factor value?
When would you use it?
What is equi join with example?
What are the ways available in sql server to execute sql statements?
What do you mean by recursive stored procedure?
What is the beast way to write CTE in SQL Server ?
What is merge?
What is normalization of database? What are its benefits?
What is the difference between sql server 2000 object owner and sql server 2005 schema? : sql server database administration
What is tabulation?
What do you mean by stored techniques? How would we use it?