Answer - select MAX(Salary) from Employee WHERE Salary <> (selec

how to get max salary with employee number by using one select
query and max function ??

Question Posted / mithilesh gatole

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

Please Help Members By Posting Answers For Below Questions

What are the properties and different types of sub-queries?

1006

Mention the 3 ways to get a count of the number of records in a table.

974

When a primary key constraint is included in a table, what other constraints does this imply?

978

Can binary strings be used in arithmetical operations?

924

How to use order by with union operators in ms sql server?

1013

What are difference between Cluster index and Non-Cluster index?

1065

What is db stored procedure?

874

What is a subquery in a select query statement in ms sql server?

1123

What is an entity-relationship diagram (erd)?

1202

what is the Ticketing tool used in Wipro technologies at Bangalore...???

8146

What is the parse query button used for?

1023

What is a data source file?

963

Is truncate autocommit?

931

What are the various editions of sql server 2017 that are available in the market?

888

Other than truncate statement, which other command can by-pass the trigger on the tables?

1125