Interview Questions Answers in SQL Server

ramnath

{ City } dfgdfg
< Country > india
* Profession *
User No # 105764

Total Questions Posted # 0
Total Answers Posted # 1

Total Answers Posted for My Questions # 0
Total Views for My Questions # 0

Users Marked my Answers as Correct # 2
Users Marked my Answers as Wrong # 2

Questions / { ramnath }

Questions Answers Category Views Company eMail

Answers / { ramnath }

Question { CSE, 6007 }

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 ?

Answer

SELECT name,min(sal) from emp1 inner join empsal where emp1.id=empsal.id

Is This Answer Correct ?

2 Yes

2 No