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 are the common performance issues in sql server?
What is create command?
Does an index slow down updates on indexed columns?
What is the difference between NOROW and LOCKROW?
What is dynamic cursor in SQL SERVER?
Explain the phases a transaction has to undergo?
Define self join in sql server joins?
Can we use having clause without group by?
What is the fillfactor concept in indexes?
What is outer join in sql server joins?
how to create “alternate row colour”?
How does normalization work?
How can you transfer data from a text file to a database table? Or how can you export data from a table to a comma delimited (csv) file? Or how can you import data from ms access to a table in a database? Or how can you export data from a table to an excel file?
What is the difference between char, varchar and nvarchar?
What are the aggregate and scalar functions?