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
- 6295 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
What are the pros and cons of putting a scalar function in a queries select list or in the where clause?
Does the unique constraint create an index?
What samples and sample databases are provided by microsoft?
How do I view a script in sql server?
Explain primary key, foreign key and unique key?
What is the most common trace flags used with sql server?
What is data compression?
What are the different types of upgrades that can be performed in sql server?
How to update muliple row in single query?
How will you know when statistics on a table are obsolete?
What is data mart? : sql server analysis services, ssas
explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
What is the difference between cartesian product and cross join?
Explain Geometry datatype in sql server 2008 with example
What is nonclustered index on computed columns?
