How many rows this query will return
Tables EMP and MANAGER has 5 records each.
How many rows will the following query return?
SELECT * FROM EMP, MANAGER
Answer:
25 rows. Each rows in EMP will have five rows of MANAGER which makes 5×5 = 25.
Categories: Database, SQL Server
Recent Comments