how to get max salary with employee number by using one select
query and max function ??
Answer Posted / mithilesh gatole
Answer -
select MAX(Salary) from Employee
WHERE Salary <> (select MAX(Salary) from Employee )
| Is This Answer Correct ? | 0 Yes | 5 No |
Post New Answer View All Answers
What is de-normalization in sql database administration? Give examples?
What according to you is the difference between mysql and sql server performance?
You have several tables, and they are joined together for querying. The tables contain both clustered indexes and non clustered indexes to optimize performance, how should you distribute the tables and their indexes onto different file groups?
Tell me what is fill factor?
What are types of scd? : sql server analysis services, ssas
What is user-defined function?
Which autogrowth database setting is good?
Are there any preferred steps that need to be taken care of before starting the installation of sql server 2000?
what are user defined datatypes and when you should go for them? : Sql server database administration
What is stored in the mssqlsystemresource database? : sql server database administration
What is used to replicate sessions between instances in coldfusion clusters?
Can group functions be mixed with non-group selection fields in ms sql server?
List the types of recovery model available in sql server?
what is the Ticketing tool used in Wipro technologies at Bangalore...???
What is ms sql server service broker?