Interested to Buy Any Domain ? << Click Here >> for more details...
how to get max salary with employee number by using one select
query and max function ??
- 3 Answers
- 8702 Views
- Genpact, I also Faced
- E-Mail Answers
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
How to receive returning result from a query?
What is constraints and its types?
What is the difference between clustered and a non-clustered index?
How do clustered indexes store data?
What is logon trigger?
Explain indexed views and partitioned view with their syntax.
Explain what is it unwise to create wide clustered index keys?
Can you explain different types of locks in sql server?
what are user defined datatypes? : Sql server database administration
What are the differences between sql server and mysql.
How to provide default values to function parameters?
Do you know what is user defined datatypes and when you should go for them?
How will you monitor replication activity and performance? What privilege do you need to use replication monitor? : sql server replication
What is failover clustering overview?
What is standby servers? Explain types of standby servers.
