How to get the count of distinct records. Please give me the
query?
Answer Posted / anilreddy
select count(distinct(columnname)) from tablename
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the main difference between ‘between’ and ‘in’ condition operators?
Why I am getting this error when renaming a database in ms sql server?
What are the types of sql server?
How to connect a database with sql express.?
What are the disadvantages of primary key and foreign key in SQL?
How can you hide the sql server instances?
Why the trigger fires multiple times in single login?
Do you know what is similarity and difference between truncate and delete in sql?
What do mean by xml datatype?
Can select statements be used on views in ms sql server?
Explain the difference between HTTP and HTTPS in database?
What is the maximum size per database for sql server express?
Explain having clause?
What is read committed?
What are the benefits of filtered indexes?