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
What is the difference between DataRow.Delete() and DataRow.Remove()?
How can we improve performance by using SQL Server profiler?
What are the advantages of paper records?
as a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this? : Sql server administration
What are the advantages of mirroring?
What are the indexes in sql server?
What are dml triggers and types of dml triggers?
Write a Select Query to display title for each group of records, which are collected with Compute Clause? Like titlefield column-A column-B ..... ..... ..... Sum ... titlefield column-A column-B ..... ..... ..... Sum ...
What is difference between Datepart() and Datename() in SqlServer?
Tell me what is the significance of null value and why should we avoid permitting null values?
Explain data warehousing in sql server?
How to define and use table alias names in ms sql server?
How to use union to merge outputs from two queries together in ms sql server?
How to name query output columns in ms sql server?
What is sql server profiler?