hi
--CREATE TABLE EMPNAME1
--(
--EMPID INT PRIMARY KEY IDENTITY(1,1),
--EMPNAME NVARCHAR(100),
--EMPSALARY DECIMAL(18,2)
--)
--Insert into EMPNAME1 VALUES('AA1',1000)
--Insert into EMPNAME1 VALUES('AA2',2000)
--Insert into EMPNAME1 VALUES('AA1',500)
--Insert into EMPNAME1 VALUES('AA2',800)
-- i NEED Highest Values only show
-- both employee highest value only need
-- I need this output
-- EMPID empname empsalary
-- 1 AA1 10000
-- 4 AA2 800
Mark as Answer if its helpful to you
Kumaraspcode2009@gmail.com