How to get the count of distinct records. Please give me the
query?
Answers were Sorted based on User's Feedback
Answer / kanika
this will also work
select count(distinct columnname) from table
Is This Answer Correct ? | 18 Yes | 1 No |
Answer / name
select count(distinct columnname) from table ,this is correct as i checked the query
Is This Answer Correct ? | 13 Yes | 1 No |
Answer / anusha
SELECT COUNT(*)FROM(SELECT DISTINCT columnname FROM
tblname)
Is This Answer Correct ? | 7 Yes | 5 No |
Answer / pradyumna
select distinct colname,count(colname) from tbl group by
colname
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / madhavi.bandreddi
select count(*) from (select distinct * from tablename)as
dummytable
Is This Answer Correct ? | 3 Yes | 2 No |
Answer / gouri
SELECT count(*) FROM
(SELECT distinct ngcode FROM donation )d
Is This Answer Correct ? | 4 Yes | 4 No |
Answer / anilreddy
select count(distinct(columnname)) from tablename
Is This Answer Correct ? | 0 Yes | 0 No |
Do you know what is a trace frag? Where do we use it?
How to connect of datebase with sql express.?
How can you list all the table constraints in a database?
What do u mean by orphan users, how will u list them in the DB
What is RAID? What are the different types of RAID configurations?
Where to find ntwdblib.dll version 2000.80.194.0?
In what sequence sql statement is processed?
can we call stored Procedure in Function in Sql Server 2000 and vice versa.
3 Answers C3I, eSoft, iPRO Solutions, Wipro,
What is the difference between value type and reference type?
how to invoke a trigger on demand? : Sql server database administration
What are the steps to follow to configure SQL*Net?
Explain the microsoft sql server delete command?