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 different type of replication in sql server?
what is raid and what are different types of raid configurations? : Sql server database administration
How to execute a sql statement using mssql_query()?
How to get a list of columns using the "sys.columns" view in ms sql server?
How do I setup a sql server database?
What is the size of transaction log file?
Can a database be shrunk with users active?
What are the acid properties?
Which event (check constraints, foreign key, rule, trigger, primary key check) will be performed last for an integrity check?
Explain hostprotectionattribute in sql server 2005?
How should i optimize the time for execution of stored procedure having single input and many output from the different tables?
What is row_number () and partition by in sql server?
You notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it?
How many full-text indexes can a table have?
Ways to improve the performance of a SQL Azure Database?
