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

What do you understand by a view?

0 Answers  


What are the difference between primary key and unique key? : sql server database administration

0 Answers  


What do you understand by SQL*Net?

0 Answers   Tech Mahindra,


Do you know what is replace and stuff function in sql server?

0 Answers  


in how many ways we can use count()

2 Answers  






How do I find sql server instance name?

0 Answers  


How do I compare two values when one value(data type) is char and the other is an integer?

3 Answers  


Can you tell me the difference between DELETE & TRUNCATE commands?

15 Answers  


How to list all dsn entries on your local machine using odbc_data_source()?

0 Answers  


Explain how many types of relationship?

0 Answers  


What is a user-defined function in the sql server and what is its advantage?

0 Answers  


What is log shipping? Can we do logshipping with SQL Server 7.0 - Logshipping is a new feature of SQL Server 2000. We should have two SQL Server - Enterprise Editions. From Enterprise Manager we can configure the logshipping. In logshipping the transactional log file from one server is automatically updated into the backup database on the other server. If one server fails, the other server will have the same db and we can use this as the DR (disaster recovery) plan.

0 Answers  


Categories