Sample SQL Queries

1. Display all the information of the EMP table?

A) select * from emp;

2. Display unique Jobs from EMP table?

A) select  distinct job from emp;

B) select unique job from emp;