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

Why cross join is used?

1085

Why we use triggers in mysql?

998

What is the difference between joins?

1050

Are left and right joins the same?

1096

What is loop in pl sql?

1043

What do you mean by table in sql?

1001

What are dml commands?

1027

what are the difference between clustered and a non-clustered index? : Sql dba

1039

What are different types of sql?

1201

What is having clause in sql?

977

What is left join in sql?

1062

what is row? : Sql dba

1233

Why query optimization is needed?

932

Is drop table faster than truncate?

1002

What is column?

1001