If tab is table name then it gives total no of rows present in that table

What does “select count(1) from tab” result?

Question Posted / prerna

Answer Posted / prerna

If tab is table name then it gives total no of rows present
in that table.

Is This Answer Correct ?

9 Yes

7 No

Please Help Members By Posting Answers For Below Questions

Can we enter data in a table in design view?

947

Are sql database names case sensitive?

979

What view means?

958

what are rollup and cube in t-sql? : Transact sql

1070

Why coalesce is used in sql?

978

what is the bond code in materialized view?

2978

describe mysql connection using mysql binary. : Sql dba

1042

How to run pl sql program in mysql?

997

What are different types of keys?

1077

define join and explain different type of joins? : Sql dba

930

What is natural join in sql?

958

How do you break a loop in pl sql?

1028

Is sql similar to python?

958

What are the 3 modes of parameter?

1144

Explain what is a subquery ?

1164