List the ways to get the count of records in a table?



List the ways to get the count of records in a table?..

Answer / Shubham Gangwar

In SQL, you can use COUNT(), COUNT(*) (counts non-null values), and COUNT(distinct column_name) to get the count of records in a table.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

What are the 3 types of behavioral triggers?

1 Answers  


How delete all records from table in sql?

1 Answers  


Does varchar need length?

1 Answers  


How do you change a value in sql?

1 Answers  


Is sql workbench free?

1 Answers  


what happens when the column is set to auto increment and you reach the maximum value for that table? : Sql dba

1 Answers  


How can i insert data inro a table with 3 columns using FORALL?

2 Answers   Oracle,


i have a table with fields(id,name,accnt_type)and in account type are FD,SAVING,RD. Write a query to get How many number of People are in each type of Account?

6 Answers   Fidelity, IBM,


What is the difference between function and procedure in pl/sql?

1 Answers  


We have a CURSOR then we need BULK COLLECT?

1 Answers  


Explain correlated query work?

1 Answers  


how to give permission to users that users can update/insert/delete on a row of table on timeing 10am to 6pm only?

4 Answers   TCS,


Categories