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
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 |
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 |
How to create a view with data from multiple tables?
What is the need for indexing?
What are extended events in sql server?
Why the trigger fires multiple times in single login?
What is Outter Join?
How to enter unicode character string literals in ms sql server?
When cursors are useful?
What is rolap and its advantage? : sql server analysis services, ssas
What will be the maximum number of index per table?
why would you call update statistics? : Sql server database administration
What is xdr?
What stored by the msdb?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)