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

in how many ways we can use count()

Question Posted / pravati

Answer Posted / 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

Please Help Members By Posting Answers For Below Questions

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

1146

Can you explain different types of locks in sql server?

992

What is delete query?

990

How do you test your database? : sql server database administration

1066

Why should one not prefix user stored procedures with ‘sp_’?

1097

Why we need to use secondry database file? though, we can do same work using primary database file also.

7006

What is the server name in sql server?

1066

What is the architecture of ms sql reporting service?

1023

What is compound operators?

1115

Will count(column) include columns with null values in its count?

1147

Where are sql server user names and passwords stored in sql server?

1154

what is a live lock? : Sql server database administration

1017

Define outer join in sql server joins?

987

What is SQL Server?

1269

How do I connect to sql server database?

1065