ALL employee Name with Max Salary

Declare @T1 Table(Eid int,Ename varchar(10))


Declare @T2 Table(Payid int,Eid int,Sal decimal)

INSERT INTO @T1(Eid,EName)Values(1,'A')

INSERT INTO @T1(Eid,EName)Values(2,'B')

INSERT INTO @T1(Eid,EName)Values(3,'C')

INSERT INTO @T1(Eid,EName)Values(4,'D')



INSERT INTO @T2(Payid,Eid,Sal)Values(1,1,500)

INSERT INTO @T2(Payid,Eid,Sal)Values(2,2,100)

INSERT INTO @T2(Payid,Eid,Sal)Values(3,3,500)

INSERT INTO @T2(Payid,Eid,Sal)Values(4,4,250)

SELECT * from @T1

SELECT * from @T2

SELECT b.sal, a.Ename From @T1 a INNER JOIN @T2 b on a.EID = b.Eid where

b.sal =(SELECT Max(Sal) From @T2)