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 the use of sql trace?

960

What is trigger and stored procedure in sql?

1045

What do you know by pl/sql cursors?

1111

What is the difference between drop and truncate commands?

1071

What is exit statement?

1020

What is time based sql injection?

965

What is pl sql script?

1036

What is exception? What are the types of exceptions?

1073

How many sql are there?

1007

How can the performance of a trigger be improved?

1050

What is trigger explain with example?

1046

How do I remove sql plus from windows 10?

1111

Describe different types of general function used in sql?

1045

Why do we need sharding?

1001

what is index? : Sql dba

1010