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

Your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files?

Explain the microsoft sql server delete command? : SQL Server Architecture

What is the appropriate number of test cases that you can write on a database?

Explain the properties of a relational table?

How do I find the transaction log size in sql server?

What is update_statistics command?

Where the sql logs gets stored? : sql server database administration

How to list all user names in a database?

what is denormalization? : Sql server database administration

What is subquery? Explain the properties of a subquery?

Can you change the data type of a column in a table after the table has been created? If so, which command would you use?

How does clustered and non clustered index work?

For more SQL Server Interview Questions Click Here