Projected only few columns in SQL Language: SELECT Ssn, Bdate, Address FROM Employee; Outputs the Ssn, Bdate and Address columns of Employee Ordered results: SELECT Lname, Ssn, Dno FROM Employee ORDER BY Lname ASC ; Outputs the Lname, Ssn and Dno of Employee ordered (in ascending order) on last name.
{}