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 |
List out a number of the wants to setup a SQL Server failover cluster?
How global temporary tables are represented and its scope?
What are the functions in sql server?
What is read uncmmited?
what is package and it uses and how can u call a package
Do you know what is raid and what are different types of raid configurations? : SQL Server Architecture
How to get a list of columns in a view using "sys.columns" in ms sql server?
How to throw custom exception in Stored Procedure?
What do you understand by the analysis services in sql server?
what is a self join? : Sql server database administration
What is one of the first things you would do to increase performance of a query? For example, a boss tells you that ?a query that ran yesterday took 30 seconds, but today it takes 6 minutes?
2 Answers Accenture, Merrill Lynch, Wipro,
What is scheduled job and how to create it?
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)