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

How do temporal tables work?

907

Can %notfound return null after a fetch?

1000

What is sql keyword?

944

What is dynamic query?

913

What are types of joins?

908

how to start mysql server? : Sql dba

1142

Is sql an operating system?

961

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

1047

What is difference between joins and union?

1043

What is a table partition?

1036

Define tables and fields in a database

1080

what is a composite key ? : Sql dba

993

What is data manipulation language?

1134

What is a database? Explain

1050

what is a primary key? : Sql dba

982