It returns the count of all tables for that user.

What does “select count(1) from tab” result?

Question Posted / phani

Answer Posted / phani

Is This Answer Correct ?

1 Yes

6 No

Please Help Members By Posting Answers For Below Questions

how to shutdown mysql server? : Sql dba

1084

how can we find the number of rows in a table using mysql? : Sql dba

1069

What are procedures used for?

971

What is the best sql course?

973

Is sql dba a good career? : SQL DBA

978

How delete all records from table in sql?

964

How are functions and procedures called in PL/SQL?

1197

How delete a row in sql?

977

what is a composite primary key ? : Sql dba

1028

Name the different types of indexes in sql and define them.

1124

Can we use view in stored procedure?

889

what is normalization? : Sql dba

1071

How do sql triggers work?

1024

What are the parts of a sql statement?

1072

What view means?

964