How to get the count of distinct records. Please give me the
query?
- 8 Answers
- 11402 Views
- Value Labs, I also Faced
- E-Mail Answers
Answer Posted / soumya
select distinct (columnname) from tablename
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
How to recompile stored procedure at run time?
Should you normalize audio?
What is the tcp/ip port on which sql server runs?
Tell me time data type, datetime2, datetimeoffset data type in sql server 2008?
How to override dml statements with triggers?
What is a print index?
Explain the various types of concurrency problem. I.e. Lost or buried updates, uncommitted dependency, inconsistent analysis, phantom read?
What is a not null constraint?
what information is maintained within the msdb database? : Sql server administration
What is perspective, have you ever created perspective? : sql server analysis services, ssas
What is a result set object returned by mssql_query()?
How to find Duplicate Records In table?
what is database replicaion? : Sql server database administration
what is an extended stored procedure? Can you instantiate a com object by using t-sql? : Sql server database administration
What are the default system databases in sql server 2000?
