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

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What does dml stand for?

496


What is the difference between createstatement and preparedstatement?

483


what is database replicaion? What are the different types of replication you can set up in sql server? : Sql server database administration

524


What is partition, how will you implement it? : sql server analysis services, ssas

593


Explain the dirty pages?

566






How to trouble shoot if unable to connect SQL Server

1478


How to connect a database with sql express.?

559


Explain subquery and state its properties?

541


Mention a few common trace flags used with sql server?

536


what’s the difference between Covering Indexes and Clustered Indexes ? how to use clustered index small ?

1565


Tell me can we use custom code in ssrs?

586


How many replicas are maintained for each sql azure db?

104


Do you know what are the reporting services components?

521


Why are views required in the sql server or in any other database?

526


Explain throw statement in sql server 2008?

575