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

What is sql server locking?

556


What is the difference between deallocate cursor and close cursor?

728


What is built-in function?

550


What extended events?

556


Explain the properties of sub-query in sql server?

516






What is difference between unique and primary key?

482


Explain the collation?

629


What is difference between rownum and rowid?

511


What is mssql?

574


Is a primary key unique?

542


What is indexed view? How to create it?

599


Which table keeps the locking information?

530


What is built-in/administrator?

580


How many databases Microsoft SQL server provides?

615


What is the user of Primary key?

581