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

How many types of functions are there in sql server?

946

Different types of keys in SQL?

1098

How many types of dimensions are there and what are they? : sql server analysis services, ssas

1068

what types of replication are supported in sql server? : Sql server database administration

1046

What options are there to delete rows on the publisher and not on the subscriber? : sql server replication

1216

How do I find the sql server version?

1025

Explain system functions or built-in functions? What are different types of system functions?

979

How do I get to sql server configuration manager?

1009

How network traffic be reduced by using the stored procedure?

1118

What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?

962

What will be query used to get the list of triggers in a database?

1003

What are different types of views?

948

What is executereader?

952

What is parameterized reports in ssrs ?

149

Can we run Reporting Services with SQL Server express edition, which is a free version of SQL Server?

118