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 action plan is preferred if sql server is not responding?

1101

What is multi-statement table-value user-defined function?

993

Describe in brief databases and sql server databases architecture.

1008

What is collation sensitivity?

1057

what are the different ways to return the rowcount of a table?

995

How to create a local temporary stored procedure?

998

What are different types of schemas?

944

Is truncate autocommit?

935

Tell me can we use custom code in ssrs?

1001

What are a scheduled jobs?

956

Explain an incremental backup?

999

What is impersonation? What are the different impersonation options available in ssas? : sql server analysis services, ssas

972

IF more than one Site is accessing the same Database server and I want to move the DB with Minimum down time? How will you do

1803

Explain about remote stored procedure?

1008

What is a result set object returned by odbc_exec()?

1027