1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

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

Question Posted / gags

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

Explain hostprotectionattribute in sql server 2005?

0 Answers  

What do you mean by the term 'normalization'?

0 Answers   Tech Mahindra,

How do you connect 100 files as a flat file sources in one package of SSIS?

2 Answers  

How to achieve Paging of records in SQL SERVER?

0 Answers   Petranics Solutions,

WHAT IS THE DIFFERENCE BETWEEN CANDIDATE KEY ,COMPOSITE KEY AND PRIMARY KEY. THAN U.

1 Answers   Synergy,




how to know Who Is Blocking Your SQL Server?

4 Answers  

how to get max salary with employee number by using one select query and max function ??

3 Answers   Genpact,

hi to all teachers,... Friends who write in the query mode Full text Search in Sql Server have experience Who make(Convert) this Stored Procedure as a normal Full text Search, which contains and .. Is used, into Advance of the tips I have thanked all friends perfection. Email : rezaafandi@yahoo.com Create PROCEDURE Sp_student @fname varchar(50), @lname varchar(50), @tel varchar(50), @code varchar(50), @adr varchar(50), @search_operation varchar(50), @totalRowCount bigint output AS begin if @search_operation = 'and' begin SELECT f3,f4,f5,f6,f7 FROM tb_student WHERE( f5 like '%' + @fname + '%' and f4 like '%' + @lname + '%' and f6 like '%' + @tel + '%' and f7 like '%' + @code + '%' and f3 like '%' + @adr +'%' ) select @totalRowCount = @@rowcount end

0 Answers  

How to find index size for each index on table?

0 Answers  

What are the rules to use the rowguidcol property to define a globally unique identifier column?

0 Answers  

What is the query and subquery?

0 Answers  

What is ms sql server triggers?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories