the result will be-- Number of rows in table T1 multiply(*) the Number o

There are two tables (T1, T2) with different rows. Find the
output of query. Select count(*) from T1,T2.

Question Posted / atul sharma

Answer Posted / atul sharma

the result will be--
Number of rows in table T1 multiply(*) the Number of rows
in table T1

Is This Answer Correct ?

31 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What is check constraint in sql server?

995

Which feature in sql server 2008 has surprised you? You can name just one. : sql server database administration

929

What is the difference in accessing db between sql server vs sql azure?

174

Explain the difference between clustered and non-clustered index?

920

tell me what are the steps you will take to improve performance of a poor performing query? : Sql server database administration

1018

What is the difference between cube operator and rollup operator? : SQL Server Architecture

1116

what's the difference between delete table and truncate table commands? : Sql server database administration

973

What will be the maximum number of index per table?

996

Explain difference between cross join and full outer join?

1003

What is the need for group functions in sql?

1078

When setting replication, is it possible to have a publisher as 64 bit sql server and distributor or subscribers as a 32 bit sql server?

936

How to convert numeric values to integers in ms sql server?

1085

What is the minimum and maximum number of partitions required for a measure group? : sql server analysis services, ssas

1043

What are wait types?

1102

How to create a testing table with test data in ms sql server?

1078