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
- 13527 Views
- Value Labs, I also Faced
- E-Mail Answers
Answer Posted / anusha
SELECT COUNT(*)FROM(SELECT DISTINCT columnname FROM
tblname)
| Is This Answer Correct ? | 7 Yes | 5 No |
Post New Answer View All Answers
is it important for a database administrator to understand the operating system and file access? : Sql server administration
What are the steps you can take to avoid “deadlocks”?
What is the native system stored procedure to execute a command against all databases?
What is a field name?
What is the difference between the export /import functions in sql studio and standalone sql manager? : sql server management studio
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database?
where the connection string store in the database
What are the instances when triggers are appropriate?
How many types of keys are there?
What are the various editions of sql server 2017 that are available in the market?
How do you debug a procedure in sql server?
What is snapshot replication?
What are the differences between stored procedure and the dynamic sql?
what are different types of backups available in sql server? : Sql server database administration
Do you know what is replace and stuff function in sql server?
