select count(1) from table name

in how many ways we can use count()

Question Posted / krishna

Answer Posted / krishna

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Which table keeps information about stored procedures?

923

What do you mean by subquery?

1069

How to Sync Two SQL Azure Databases?

119

What is tempdb in sql server?

949

How can we solve concurrency problems?

1035

Explain different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?

1016

Explain the different types of backups available in sql server? : sql server database administration

902

How you can get a list of all the table constraints in a database?

941

How is foreign key related to primary key?

953

Is the primary key column of a table an index in ms sql server?

946

IF more than one Site is accessing the same Database server and I want to move the DB with Minimum down time? How will you do

1789

What is nonclustered index on computed columns?

938

Why I have to use stored procedures?

1017

What is user-defined function? Explain its types i.e. Scalar and inline table value user-defined function?

887

Explain can SSRS reports Cache results?

158