You can use * to retrieve all the attribute values of the selected tuples. SELECT * FROM EMPLOYEE WHERE DNO=5