Interested to Buy Any Domain ? << Click Here >> for more details...
How to get the count of distinct records. Please give me the
query?
- 8 Answers
- 13274 Views
- Value Labs, I also Faced
- E-Mail Answers
Answer Posted / kanika
this will also work
select count(distinct columnname) from table
| Is This Answer Correct ? | 18 Yes | 1 No |
Post New Answer View All Answers
How can you check the level of fragmentation on a table?
What is the default sql server instance name?
What is the difference between functions and stored procedures?
I applied Transactional with updatable subscriptions replication on 2 tables now i want to delete those 2 tables but i cannot delete those tables as replication is running how can i stop replication for those 2 tables(but i don't want to delete those replicated tables but i need to stop the replication) how can i do that
Does view occupy space?
How do I view views in sql server?
Why I am getting this error when renaming a database in ms sql server?
What are different types of statement?
What are dml (data manipulation language) statements in ms sql server?
How many joins in sql server?
Write query to return all rows sql?
mention different types of relationships in the dbms?
Is there any difference between primary key and unique with the not null condition?
Where are SQL server users names and passwords are stored in sql server?
What do you understand by the analysis services in sql server?
