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

Define overloaded procedure?

1076

How do we accept inputs from user during runtime?

1054

What is attribute indicator in pl sql?

1011

what tools available for managing mysql server? : Sql dba

1076

What is the function that is used to transfer a pl/sql table log to a database table?

1008

What does the acronym acid stand for in database management?

1030

Explain autonomous transaction.

1152

What is the difference between mdf and ndf files?

1115

What is the need of a partition key?

981

How many triggers can be applied on a table?

930

Explain how can you save or place your msg in a table?

1026

What is a table?

1007

What is difference between left and right outer join?

981

what is an alias command? : Sql dba

1102

What type of database is sql?

1021