in how many ways we can use count()

Answer Posted / krishna

select count(1) from table name

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can You Use A Stored Procedure To Provide Data To An Ssrs Report?

129


How many types of functions are there in sql server?

628


How can you hide the sql server instances?

750


what is denormalization? : Sql server database administration

684


Explain comment on transactions?

748


Which are new data types introduced in sql server 2008?

834


What is a trace frag?

844


What will be query used to get the list of triggers in a database?

766


What are the differences between local and global temporary tables?

775


What do you mean by the term 'normalization'?

879


How to integrate the ssrs reports in application?

737


What are the differences between decimal and float in ms sql server?

785


What are difference between Cluster index and Non-Cluster index?

807


What are the purposes and advantages stored procedure?

705


Explain an automatic checkpoint

737