Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / pravati
In two ways we can use count
1. SELECT COUNT(*) FROM table name.
2.SELECT COUNT(DISTINCT *) from table name.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the cartesian product of the table?
What do you mean by data manipulation language?
How much memory that we are using in Logshipping Concept?
How to convert numeric expression data types by assignment operations?
What is the default Port No on which SQL Server listens?
What is the significance of master, tempdb and model databases?
What does the update command do?
Mention the differences between substr and charindex in sql server.
How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?
What is the difference between insensitive and scroll cursor?
What is de-normalization in sql database administration? Give examples?
Do you know what are the steps to process a single select statement?
What is awe?
What happens if null values are involved in boolean operations?
How do I find the default sql server instance?
