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
Define SQL and state the differences between SQL and other conventional programming Languages?
What is the location of pre_defined_functions.
How many types of relationship are there?
Why procedure is used in sql?
What is a call statement? Explain with an example.
what is a trigger? : Sql dba
Why do we use sqlite?
What is the use of pl/sql table?
What is a .db file?
Is it possible to sort a column using a column alias?
What are the different tcl commands in sql?
What are field types?
what does myisamchk do? : Sql dba
what is union? : Sql dba
Why use subqueries instead of joins?