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).
Answer Posted / raju
SELECT NAME ,SAL FROM employee WHERE
SAL=(SELECT MAX(sal)from employee )
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to identify current user in ssrs report?
How you can get the list of largest tables in a database?
Give the query of getting last two records from the table in SQL SERVER?
What is a transactions?
What is the difference between cartesian product and cross join?
How to create view in stored procedure sql server?
what is the system function to get the current user's user id? : Sql server database administration
in a table is b in column k (manikanta,sivananda,muralidhar) i want result like (mnikanta,sivnanda,murlidhar) please slove it
What is the size of transaction log file?
Define views.
Name some of the open source software that you can use in alternative to SSR?
What are the different ways you can create databases in sql server?
What is catalog views?
you have couple of stored procedures that depend on a table you dropped the table and recreated it what do you have to do to reestablish those stored procedure dependencies?
Does the order of columns in update statements matter?