1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

in how many ways we can use count()

Question Posted / raghavendar

Answers were Sorted based on User's Feedback



in how many ways we can use count()..

Answer / 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

in how many ways we can use count()..

Answer / krishna

select count(1) from table name

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL Server Interview Questions

What is Full Outer Join?

3 Answers  

When do you use SQL Profiler?

3 Answers   Wipro,

Define inner join? Explain with an example?

0 Answers  

Explain transaction server implicit?

0 Answers  

Explain log shipping?

0 Answers  




What will be the value of @@fetch_status if a row that was a part of the cursor resultset has been deleted from the database after the time the stored procedure that opened the cursor was executed?

0 Answers  

Can we perform backup restore operation on tempdb? : sql server database administration

0 Answers  

What is a trigger in sql server?

0 Answers  

What is the command used to get the version of sql server?

1 Answers  

how many clustered indexes can be created on a table? : Sql server database administration

0 Answers  

What are sparse columns?

0 Answers  

What are explicit and implicit transactions?

4 Answers   BirlaSoft,

For more SQL Server Interview Questions Click Here
Categories