1. Categories >> Software >> Databases >> DB Development
  2. Suggest New Category

Write the fastest query to find out how many rows exist in a table?

Question Posted / nitin kumar


Write the fastest query to find out how many rows exist in a table?..

Answer / Vivek Kishor

The fastest way to get the number of rows in a table is using the COUNT(*) function. However, if you want an exact count without considering NULL values, use COUNT(column_name) where column_name refers to a non-nullable column.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More DB Development Interview Questions

can you give me the syntax of named procedure??

2 Answers  

Explain about network model?

1 Answers  

what is the use of foreginkey

2 Answers  

How long can an error message be in raiseerror function?

1 Answers  

State the acid rules?

1 Answers  

Define candidate key, alternate key, composite key?

30 Answers   IAS, IBM,

What is database design and development?

1 Answers  

Explain about the database management systems.

1 Answers  

explain detail about ftp in datastage?

1 Answers   IBM,

What is an extended stored procedure?

1 Answers  

Can you have a nested transaction?

1 Answers  

What are the three types of database design?

1 Answers  

For more DB Development Interview Questions Click Here
Categories