How to get the count of distinct records. Please give me the
query?
Answer Posted / soumya
select distinct (columnname) from tablename
Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
Are semicolons required at the end of sql statements in sql server 2005?
what are triggers? : Sql server database administration
What is log ldf?
Explain what is lock escalation?
Can we add an identity column to decimal datatype?
What is Cross Join and in which scenario do we use Cross Join?
What are Spatial data types in SQL Server 2008
What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?
Can a table have 2 foreign keys?
How do you improve the performance of a SQL Azure Database?
Can you please explain the difference between primary keys and foreign keys?
what is an extended stored procedure? : Sql server database administration
Explain “not null constraint” in sql server?
Explain acid?
How can I add Reporting Services reports to my application?