there is A table and B table in A table there 5 rows and in
b table there are 2 rows i am firing query select * from
a,b what will be the output?
Answer Posted / subbu
It is a cross join
So, the output is 5*2=10
| Is This Answer Correct ? | 13 Yes | 0 No |
Post New Answer View All Answers
What is a left join?
Is nosql faster than sql?
Why truncate is faster than delete?
how to drop an existing table in mysql? : Sql dba
Does pl sql work in mysql?
What is number function in sql?
What is primary key and unique key?
What is difference between left and right outer join?
What is a recursive stored procedure?
Is sqlite good enough for production?
What is a temp table?
What is the max nvarchar size?
What is sap sql?
What is the difference between microsoft sql and mysql?
Write a program that shows the usage of while loop to calculate the average of user entered numbers and entry of more numbers are stopped by entering number 0?