in how many ways we can use count()

Question Posted / raghavendar

Answers were Sorted based on User's Feedback

in how many ways we can use count()..

Answer / pravati

In two ways we can use count
1. SELECT COUNT(*) FROM table name.
2.SELECT COUNT(DISTINCT *) from table name.

Is This Answer Correct ?

0 Yes

0 No

in how many ways we can use count()..

Answer / krishna

select count(1) from table name

Is This Answer Correct ?

0 Yes

0 No

More SQL Server Interview Questions

What are user defined functions in ms sql server?

Explain comment on transactions?

how many layers of tcp/ip protocol combined of? : Sql server database administration

What are the steps need to be take improve the speed of a SQLDATA Server?

Explain syntax for viewing trigger?

What are trace flags and mention a few common trace flags used with sql server?

What is the difference between UNION and UNIONALL?

What is acid properties?

what is a correlated sub-query? : Sql server database administration

Observed that some SP’s / Jobs are processing late, how to troubleshoot to improve performance?

What is normalization of database? What are its benefits?

What is the query and subquery?

For more SQL Server Interview Questions Click Here