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 ?
Answers were Sorted based on User's Feedback
Answer / gajula.lavanya
SELECT T1.NAME,T2.SAL FROM emp1 T1,emp2 T2
WHERE T1.ID=T2.ID AND T2.SAL=(SELECT MAX(SAL) FROM emp2);
Is This Answer Correct ? | 1 Yes | 0 No |
SELECT name,min(sal) from emp1 inner join empsal where emp1.id=empsal.id
Is This Answer Correct ? | 2 Yes | 2 No |
Answer / kanagavel
with cte
as
(
SELECT name,max(sal) as 'sal'
from emp1 inner join empsal
where emp1.id=empsal.id
group by name
)
select top 1 *
from cte
order by sal desc
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / 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 |
Answer / ganesh
with cte as
(
select *,row_number() over(order by salary desc) as rowno
from empsal
)
select * from emp e join cte c
on e.id=c.id
where c.rowno=1
Is This Answer Correct ? | 2 Yes | 3 No |
Which is best Subquery (or) joins in sql server? explain why
How to delete duplicate rows from table except one?
what is an index? : Sql server database administration
Explain the collation?
Diffrent types of function
Can a table have 2 foreign keys?
How to divide query output into multiple groups with the group by clause in ms sql server?
How to perform key word search in tables?
What is change data capture (cdc) feature?
Is it possible to import data directly from t-sql commands without using sql server integration services? If so, what are the commands?
How to view existing indexes on an given table using sys.indexes?
Explain the different index configurations a table can have?