How to get the count of distinct records. Please give me the
query?
- 8 Answers
- 11398 Views
- Value Labs, I also Faced
- E-Mail Answers
Answer Posted / madhavi.bandreddi
select count(*) from (select distinct * from tablename)as
dummytable
| Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
How do you rename a table in sql server?
What is sql azure database?
you have couple of stored procedures that depend on a table you dropped the table and recreated it what do you have to do to reestablish those stored procedure dependencies?
What are the diifferences between the ms sql server vs mysql?
How to convert numeric values to integers in ms sql server?
How to use the inserted and deleted pseudo tables?
How to get @@error and @@rowcount at the same time?
What is provisioning, billing and metering, and connection routing concepts in the service layer?
Explain the rules for designing files and file groups in sql server?
How to copy data from one table to another table?
What are data resources?
What are the disadvantages of primary key and foreign key in SQL?
How to write character string constants or literals in ms sql server?
What is single-user mode?
How to backup SQL Server Reporting Services ?
