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

Answers were Sorted based on User's Feedback



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

Answer / 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

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

Answer / prabhash yadav

yes multiply both tables rows

Is This Answer Correct ?    23 Yes 0 No

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

Answer / jitendra sharma caresoft inc.

No of rows in table T1 * No of rows in table T2

Is This Answer Correct ?    9 Yes 0 No

Post New Answer

More SQL Server Interview Questions

Is candidate a key?

0 Answers  


What have included columns when we talk about sql server indexing?

0 Answers  


What is the difference between the application object and session object?

0 Answers  


Explain the dirty pages?

0 Answers  


Explain datetime2 data type in sal server 2008?

0 Answers  


How to change a login name in ms sql server?

0 Answers  


How to create a new schema in a database?

0 Answers  


What is awe?

0 Answers  


How you can find out if an index is useful to the optimizer?

0 Answers  


What is dml command?

0 Answers  


What is a data source file?

0 Answers  


What are “lock” hints?

0 Answers  


Categories