How to get the count of distinct records. Please give me the
query?
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 to throw custom exception in Stored Procedure?
Issues related in upgrading SQL Server 2000 to 2005 / 2008
How can a user-defined datatype be created?
What is hierarchy, what are its types and difference between them? : sql server analysis services, ssas
What is the maximum size of a row in sql server?
What do you need to connect php to sql server?
How to end a stored procedure properly in ms sql server?
Explain sql server service broker?
Define right outer join in sql server joins?
What is model database? : SQL Server Architecture
What are different types of collation sensitivity?
Do you know what is bit data type and whats the information that can be stored inside a bit column?
how many layers of tcp/ip protocol combined of? : Sql server database administration
Do you know concepts and capabilities of sql server?
Can we join two tables without primary key?