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 importance of a recovery model?

Why is DML provided?

Which is the best place or learning center for MS SQL?????In Bangladesh?????

How to convert a table data in XML format in sql server?

Describe how to use linked server?

What is normalization in Database ?

What is a trace frag? Where do we use it?

what are candidate key, alternate key and composite key? : Sql server database administration

Explain Capacity planning to create a database? and how to monitor it?

How do I start sql server?

What command is used to delete a table from the database in the sql server and how?

1.what is stored procedure?Its significance with example? 2.Explain about index with syntax and example? plz do reply.........

For more SQL Server Interview Questions Click Here