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
- 13236 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
Describe how to use the linked server?
What are the advantages to use stored procedures?
What is the difference in accessing db between sql server vs sql azure?
How can you insert values in multiple rows using one Insert statement?
Explain the types of indexes.
How to start and end transact-sql statements?
What are different types of join?
Which language is supported by sql server?
How many types of schemas are there?
i have made a project i vb.net n created a .exe of it after installing it in to any pc, the database (sql express) is not geting accesed i.e the aplication cuts the link of the database, so plz help in this matter.
What is Cross Join and in which scenario do we use Cross Join?
How to get the definition of a user defined function back?
what is a check constraint?
How can we delete a table in sql server?
What are constraints?
