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

How can you get sql*loader to commit only at the end of the load file? : aql loader

553

describe mysql connection using mysql binary. : Sql dba

552

what is the difference between delete and truncate commands? : Sql dba

537

what are the features and advantages of object-oriented programming? : Sql dba

547

give the syntax of grant and revoke commands? : Sql dba

616

what is heap table? : Sql dba

608

What does pl sql stand for?

655

Why trigger is used in sql?

530

What is a temp table?

566

How to change a value of the field ‘salary’ as 7500 for an employee_name ‘john’ in a table employee_details?

903

Which are the different types of indexes in sql?

563

Can 2 queries be executed simultaneously in a distributed database system?

643

what is a trigger in mysql? : Sql dba

602

Can we create view in stored procedure?

525

Is a view faster than a stored procedure?

545