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

how to take backup bcp out for a column in table in sql server?

2114

What is sql or structured query language?

1160

How to provide default values to stored procedure parameters?

1074

Does hive support indexing?

971

Name the different type of indexes in sql?

974

Why we need to use secondry database file? though, we can do same work using primary database file also.

6907

How you can get a list of all the table constraints in a database? : Sql server administration

1038

Explain indexing and what are the advantages of it?

1037

What are the types of joins in sql?

1138

How to insert stored procedure result into temporary table?

1028

What is a primary key?

963

What is database replication? What are the different types of replication you can set up in sql server?

965

What are xml indexes?

959

whats the maximum size of view state??

2198

What are the different index configurations a table can have?

974