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

What is an oracle stored procedure?

596

What is the difference between a primary key and a unique key?

566

What is offset in sql query?

598

how to escape special characters in sql statements? : Sql dba

520

what are the drivers in mysql? : Sql dba

563

How can we avoid duplicating records in a query?

570

What are the two characteristics of a primary key?

497

What are the conditions an underlying table must satisfy before a cursor can be used by a positioned update or delete statement? : Transact sql

547

What is aggregate function in sql?

541

Can we have two clustered index on a table?

568

Can I join the same table twice?

531

What is serial sql?

533

Is primary key clustered index?

531

can sql servers linked to other servers like oracle? : Sql dba

560

how can we repair a mysql table? : Sql dba

544