select count(*) from table

How do u count no of rows in a table?

Question Posted / siri

Answer Posted / siri

select count(*) from table_name

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

which types of join is used in sql widely? : Sql dba

542

What is the difference between sql and mysql?

560

What is a pdo connection?

519

What is the difference between a database and a relational database?

562

What is count * in sql?

558

How do you break a loop in pl sql?

529

What are sql functions? Describe in brief different types of sql functions?

492

What sql database should I use?

553

what are date and time data types in mysql? : Sql dba

504

What are the three forms of normalization?

535

Define commit, rollback and savepoint?

580

What is forward declaration in pl sql?

590

What are analytic functions in sql?

552

Does inner join return duplicate rows?

521

How do you identify a primary key?

635