select count(*) from (select distinct * from tablename)as dummytable

How to get the count of distinct records. Please give me the
query?

Question Posted / madhavi.bandreddi

Answer Posted / madhavi.bandreddi

select count(*) from (select distinct * from tablename)as
dummytable

Is This Answer Correct ?

3 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What command must you use to include the not null constraint after a table has already been created?

1053

What are the dmvs? : sql server database administration

1005

What is replication and database mirroring?

993

What is primary key, unique key, and foreign key?

919

What is use of attribute hierarchy ordered ? : sql server analysis services, ssas

962

How is SQL Azure different than SQL server?

223

What are the main sources of data?

1040

Is a null value equal to anything? Can a space in a column be considered a null value? Why or why not?

996

How many ways to create table-valued functions?

935

Do you know what is difference between stored procedure and user defined function?

1033

what's new in sql server 2016?

909

Give a example to search fr a string in all stored procedure in sql server.

914

How does stuff differ from the replace function?

960

Explain what is public role in sql server?

1060

What is an identity?

939