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

Find columns used in stored procedure?

0 Answers  

what is Data Transformation Services (DTS) ?can u explain me in detail?

5 Answers   TCS,

What is the difference between for xml raw and for xml auto?

0 Answers  

can any one please send sql quries most used in applications.

2 Answers  

Does sql server 2000 full-text search support clustering?

0 Answers  




About Indexed Views? with example? plz reply...

2 Answers  

i have table students with fields classname,studname select * from students classname studname 1 xxxxx 1 yyyy 1 zzzz 2 qqqq 2 tttt 3 dsds 3 www i want the output should be No of students in class 1 : 3 No of students in class 2 : 2 No of students in class 3 : 2

5 Answers   HCL, ZX,

What have included columns when we talk about sql server indexing?

0 Answers  

What is the synonym of join?

0 Answers  

Scalability, Availability, Integration with internet, etc.)?

0 Answers  

How do I view views in sql server?

0 Answers  

What is an identity column in insert statements?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories