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
- 8837 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
Suppose you want to implement the following relationships while designing tables. How would you do it?a.) One-to-oneb.) One-to-manyc.) Many-to-many
Explain use of expression builder.
Describe the functionalities that views support.
What is a sql join?
What is a non-clustered index?
What is a fan-out query in SQL Azure?
How can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role?
How to Improve the performencs of SQL Server 2005 exclude stored Procedure and Indexes?
Create a dts package to produce a text file using the ‘update statistics’ command for the tables in a database with obsolete statistics.
What is 'write-ahead log' in sql server 2000 ?
What do you mean by an execution plan? Why is it used? How would you view it?
Which tools are available to manage SQL Azure databases and servers?
What is your recommendation for a query running very slow? : sql server database administration
on line cluster can we make if yes tell me the procedure
How does recursive cte works in sql server?
