How do you find the number of rows in a table?

Answer Posted / elumalai.k

select @@rowcount
select count(*) from tablename

Is This Answer Correct ?    5 Yes 7 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is key attribute?

607


How many null values we can have in a unique key field in sql server?

639


What is the most common type of join?

625


Define Unique Key?

678


Explain cdc and sql injection?

630






What is user defined datatypes and when you should go for them?

674


How to store and query spatial data?

640


Does windows server 2016 come with sql server?

587


What are the advantages of the mirroring?

663


Explain the collation?

727


What are cursors? Explain the different types of cursors Enlist a few disadvantages of cursors.

699


Describe triggers features and limitations?

594


Mention the 3 ways to get a count of the number of records in a table.

625


write an SQL query to list the employees who joined in the month of January?

1261


What is data compression?

644