Interested to Buy Any Domain ? << Click Here >> for more details...
An employee table, with the columns id, name, sal and dob.
Query to select emp names of all highest salaries(there are
4-5 people having the same salary which happens to be the
highest).
- 9 Answers
- 16203 Views
- ADP, I also Faced
- E-Mail Answers
Answer Posted / jayabharathi
Select empname,salary from emp where salary=(select
max(salary) from emp)
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
What are the purpose of Normalisation?
You want to check the syntax of a complicated update sql statement without executing it. What command should you use?
What number aggregate functions are accessible there in sql?
Why it is recommended to avoid referencing a floating point column in the where clause?
explain what is raid and what are different types of raid configurations? : Sql server database administration
How to provide values to stored procedure parameters in ms sql server?
What happens if the update subquery returns multiple rows in ms sql server?
What are different types of statements that are supported by sql?
when you create a database how is it stored? : Sql server database administration
How will you decide the active and passive nodes?
How to change the system date and time from SQL Plus Terminal ?
How check triggers in sql server?
Explain microsoft sql server functions?
Explain about merge replications?
What is sql language?
