How maney row would be print after join if A table have 100
rows and B table have 50 rows...
- 9 Answers
- 12268 Views
- Hewitt, I also Faced
- E-Mail Answers
Answer Posted / tnt
IF TWO TABLE A(100) AND B(50) ARE PARTICIPATE IN NO
SPECIFIC JOIN THEN IT WILL BE CROSS JOIN LIKE THIS
SELECT A.ROW,B.ROW FROM A,B
IT WILL GIVE 100*50 RESULT
| Is This Answer Correct ? | 0 Yes | 3 No |
Post New Answer View All Answers
What is the difference between upgrade and migration in sql server?
If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?
How do I start sql server 2017?
How can I check that whether automatic statistic update is enabled or not?
How do I find query history in sql server?
Is it possible to have clustered index on separate drive from original table location?
what is the Ticketing tool used in Wipro technologies at Bangalore...???
What are different types of constraints?
Explain system functions or built-in functions? What are different types of system functions?
explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
Can one drop a column from a table?
Explain “row_number()” in sql server with an example?
How to convert numeric expression data types using the cast() function?
What is standby servers? Explain types of standby servers.
How raid can influence database performance?
