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
- 6210 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
Is it possible to call a stored procedure within a stored procedure?
What is truncate table?
What is a View ? Can we insert, Update and delete a view?
What is standby servers? Explain types of standby servers.
what is a self join? : Sql server database administration
I have a table Events Events containing cardno,time,id,name--each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible
What is buffer cash in sql server?
How to get the definition of a stored procedure back?
What is the difference between varchar and nvarchar datatypes?
What are distributed partitioned views?
what are different types of backups available in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
What is replication with database mirroring? : sql server database administration
What is format parameter in ssrs?
Can binary strings be used in arithmetical operations?
What are the joins in sql server? : sql server database administration
