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 is the difference RDBMS and Graph Database?

What is the difference between seek predicate and predicate?

how to rest identity columns in sql server

What is constraints and its types?

Does a sql server 2005 select statement require a from?

Explain about local stored procedure?

What is difference between getdate and sysdatetime in sql server 2008?

hi i gone though satyam interview. what is Acid Properties?

Why are you getting errors when creating a new odbc dsn?

What is the difference between for xml raw and for xml auto?

How to delete duplicate rows in sql server?

Do you know what is difference between stored procedure and user defined function?

For more SQL Server Interview Questions Click Here