using a join on 2 tables select all columns and


Using a join on 2 tables, select all columns and 10 rows from the 2 tables without the use of a Cartesian product.

Query:

SELECT * FROM EMPLOYEE1 E JOIN STAFF S ON E.EMP_ID=S.EMP_ID WHERE ROWNUM<11;

Use group by & having in a select statement using one or more table(s) (If more than 1 table then, don't use a Cartesian product).

Query:

SELECT BRANCH,COUNT(*) FROM STAFF  GROUP BY BRANCH;

 

 

Request for Solution File

Ask an Expert for Answer!!
PL-SQL Programming: using a join on 2 tables select all columns and
Reference No:- TGS0210878

Expected delivery within 24 Hours