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

Write a sql select query that only returns each name only once from a table?

760

What is difference between sql and oracle?

778

what are the features and advantages of object-oriented programming? : Sql dba

727

What is sqlca in powerbuilder?

746

what is row? : Sql dba

935

what is an alias command? : Sql dba

729

What is data manipulation language?

880

What is %type in pl sql?

712

Which data dictionary views have the information on the triggers that are available in the database?

941

What is the file extension for sql database?

672

What is the use of double ampersand (&&) in sql queries? Give an example

811

Can you join a table to itself?

712

how to drop an existing table in mysql? : Sql dba

758

Why use subqueries instead of joins?

797

How can a function retun more than one value in oracle with proper example?

805