Hi,
Try to Use WITH and ROW_NUMBER() FUNCTION as follows
WITH employeeDtls(Row_Number,emp_id,emp_name,sal)
AS
( SELECT ROW_NUMBER() OVER(ORDER BY emp_id) 'Row_Number',emp_id, emp_name,sal
FROM employee
)
SELECT emp_id, emp_name,sal FROM employee
WHERE Row_Number = (SELECT COUNT(emp_id) FROM employee)
Regards,
GVPrabu