( NOTE : ABOVE ADVANTAGE IS WE CAN DISPLAY ONLY WHAT WE NEED THAT THINGS ONLY WE CAN ADD TO QUERY BUT ALL THE INNER QUERIES ARE EXECUTED BUT WE CAN RESTRICT WHAT DISPLAY IN OUTER SUBQUERY) ...
#1. Display all records from the employee table. SELECT * FROM employees; #2. Show employees names and salaries only. SELECT emp_name, salary FROM employees; #3. List all departments from the ...