How to get the count of distinct records. Please give me the
query?
Answer Posted / name
select count(distinct columnname) from table ,this is correct as i checked the query
| Is This Answer Correct ? | 13 Yes | 1 No |
Post New Answer View All Answers
explain different types of backups avaialabe in sql server? : Sql server database administration
What is the difference between DataRow.Delete() and DataRow.Remove()?
How to write character string constants or literals in ms sql server?
What stored by the model?
What is page in sql server?
How to verify the port number of the sql server?
What are recommended options to be used while using db mirroring? : sql server database administration
How to apply filtering criteria at group level with the having clause in ms sql server?
What is nonclustered index with included columns ?
Would you store your query in a ssrs report or a database server? State the reason why?
What is data set in report?
In one interview...interviewer ask me question pleas tell me sql server architecture.. can any body tell me the sql server architecture with digram
What is the concept of optimization?
What are the events recorded in a transaction log?
code to create procedure for taking databse backup in sql server or i have the query for it but what it's query returns means i want to show on my jsp that the databse backup has been taken on the basis of that return value.does it returns 0 or 1.wat is the code for that