Write a single SELECT statement which would return 16 rows.

Rajeev Kumar

There is a table with 4 rows. Write a single SELECT statement which would return 16 rows. Use of temp table, CTE, Union all, and JOIN is not allowed

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sachin Singh3y ago
Accepted answer
select * from tableName t1, tableName t2

. Idk might be cross join he was talking about as we don't need to use join keyword for cross join.

but this question doesn't make sense.
+1
Tuhin Paul3y ago
One way to achieve this is by using CROSS JOIN with the table itself:
```
SELECT t1.*, t2.*
FROM table_name t1
CROSS JOIN table_name t2;
```
This will return a total of 16 rows (4 x 4), with each row joined with every other row in the table.
+1
Rajeev Kumar3y ago
@Rijwan Ansari someone ask a quetion to me. I was also surprised to listen this question also.
+1
Rijwan Ansari3y ago
Hi,

I am not sure about your question, however, if you have 4 rows in a table, why/how can you need to return 16 rows?
+1