select count(1) from <table_name>; By this also we can count no of

How do u count no of rows in a table?

Question Posted / bj

Answer Posted / bj

select count(1) from <table_name>;

By this also we can count no of rows in a table.

Is This Answer Correct ?

19 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What is the source code of a program?

1005

What is the need of merge statement?

989

What is the sql query to display the current date?

992

Does execute immediate commit?

1153

What are the different types of database management systems?

951

Which is faster union or join?

903

Which is the correct statement about truncate and delete?

1036

Why trigger is used in sql?

917

what are ddl statements in mysql? : Sql dba

1114

Is sqlexception checked or unchecked?

920

What is meaning of <> in sql?

1023

What is nested table in pl sql?

1007

Define a temp table?

967

How can a function retun more than one value in oracle with proper example?

1029

Is foreign key mandatory?

939