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 are the advantages to use stored procedures?

1083

what are the types of indexes? : Sql server database administration

1097

Mention a few common trace flags used with sql server?

916

What are subqueries in sql server? Explain its properties.

996

what is the system function to get current user's user id? : Sql server database administration

981

What is the difference between function and stored procedure in sql server?

1044

How to create dbo table in sql server?

933

what does the automatic recovery do? : Sql server administration

1004

Difference between drill down and drill through report.

937

Explain powershell included in sql server 2008?

1039

Can we write trigger for view?

995

Does a full backup include transaction log?

949

what authentication modes does sql server support? : Sql server database administration

1071

Is ssrs support other database except ms sql server?

139

What are the advantages of user-defined functions over stored procedures in sql server?

1017