Interested to Buy Any Domain ? << Click Here >> for more details...
two tables are there.1st table EMP has two columns ID and name and contains data 1,A
2,B
3,C
2nd table EmpSal has 2 columns ID and Salary
Contains data -1,1000
2,5000
3,3000
Find name of employee having maximum salary ?
- 5 Answers
- 6008 Views
- CSE, I also Faced
- E-Mail Answers
Answer Posted / b.kumar
--BY USING MS SQL SERVER
SELECT TOP 1 * FROM
(SELECT DISTINCT TOP 1 #A.ID,#A.NAME,#B.SAL
FROM #A INNER JOIN #B ON #A.ID=#B.ID ORDER BY SAL) E
ORDER BY SAL
--HERE #A, #B ARE TEMP TABLES
--E IS ALIAS NAME
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain what is cte (common table expression)?
How do I start sql server?
Explain cdc and sql injection?
you added a row to a view, but the row is not shown on the view. Explain how this can happen, and how you can remedy the situation
What are the new features in SQL Server 2005 when compared to SQL Server 2000?
What is a trigger? Why we need it?
Can we shrink data file in sql server?
Do you know what are the steps to process a single select statement?
What is coalesce and check constraint in sql server?
What the different types of Replication and why are they used?
what is the system function to get current user's user id? : Sql server database administration
What are different types of subquery?
What is the use of group by clause?
How will you know when statistics on a table are obsolete?
Explain what are various ways to enhance the ssrs report?
