Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 7 Answers
- 13879 Views
- Cognizant, I also Faced
- E-Mail Answers
Answer Posted / santosh pashte
It is concept of CROSS JOIN..
It will display 5 * 2 = 10 rows
| Is This Answer Correct ? | 41 Yes | 4 No |
Post New Answer View All Answers
How does postgresql compare to "nosql"?
What is the difference between sum and count in sql?
a table has 2 classifications 1)liabilities 2)earnings this liabitity has 2 elements with 2 input values and the earnings have 2 elements with 2 input values i wrote a query so that my input is liability savings amount1 amount2 xxxx null xxxxxx 0 xxx1 null xxxxx1 0 null yyyy 0 yyyy null yyy1 0 yyy1 my problem is --when i developed a report(d2k) with this data my o/p is liabilities,amount1,savings,amount2 xxxx xxxxxx xxx1 xxxxx1 yyyy yyyy yyy1 yyy1 how could i move this savings,savings values 2 palces up. can any body provide me witha better solution
How do I count rows in sql?
How to select random rows from a table?
Can sql function call stored procedure?
What is the purpose of a sql?
what is the difference between sql and t-sql? : Transact sql
What are instead of triggers?
What is pl sql record in oracle?
What is using in sql?
how to delete an existing column in a table? : Sql dba
Explain the difference in execution of triggers and stored procedures?
how do you login to mysql using unix shell? : Sql dba
Explain constraints in sql?
