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 database architecture? : SQL Server Architecture

What is save transaction and save point?

What is table valued function and scalar valued functions?

how will u create "n" possible tables in sql...

how to know description of a table in sqlserver 2000

default databases available in sql server and there uses ?

In which format does an image save in SQL Server database ?

Explain insert into select statement?

How do you load large data to the SQL server database?

How except clause is differs from not in clause?

How to provide column names in insert statements in ms sql server?

What is "scheduled jobs" or "scheduled tasks"?

For more SQL Server Interview Questions Click Here