SQLize Online / PHPize Online  /  SQLtest Online

CREATE TABLE Employee ( ID INT primary key, FirstName Varchar(100), LastName Varchar(100), Country Varchar(100) ); Insert into Employee (ID, FirstName,LastName,Country )values(1, 'Raj','Gupta','India'), (2,'Raj','Gupta','India'), (3,'Mohan','Kumar','USA'), (4,'James','Barry','UK'), (5,'James','Barry','UK'), (6,'James','Barry','UK'); select * from Employee WHERE ID NOT IN (SELECT MAX(ID) AS MaxRecordID FROM Employee GROUP BY Firstname, LastName, Country);