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

Categories >> Software >> Databases >> SQL PLSQL
Suggest New Category

Question Posted / vinod

10 Answers
21383 Views
IBM, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

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

Answer / gourvendra singh

select count(1) from tab will give the total number of
tables,views and synonms present in the current schema.

Is This Answer Correct ?

61 Yes

6 No

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

Answer / vishnu

SELECT COUNT(1) FROM TAB

ANS:It gives the total number of tables,views,synonyms
present in that schema.

Is This Answer Correct ?

23 Yes

2 No

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

Answer / 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

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

Answer / sunil

Tab is system view which will provide you the list of
table,view,cluster,synonym in the current schema .

Is This Answer Correct ?

1 Yes

0 No

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

Answer / guest

it results out the count of record in the table result

Is This Answer Correct ?

1 Yes

1 No

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

Answer / rutujagabhane

select* from tab; gives you the o/p as a table containing rows and columns. The rows contain the name of table ,select count(1) from tab returns the no or rows in tab .
Indirectly the statement returns no of tables in tab;

Is This Answer Correct ?

0 Yes

0 No

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

Answer / phani

It returns the count of all tables for that user.

Is This Answer Correct ?

1 Yes

6 No

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

Answer / indrajeet kumar

SELECT COUNT(1) FROM TAB

RESULT IS 91

Is This Answer Correct ?

2 Yes

17 No

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

Answer / ali

A column function does not use any column name.

Is This Answer Correct ?

3 Yes

20 No

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

Answer / mahi

It will give the latest row of the table.

Is This Answer Correct ?

2 Yes

51 No

Post New Answer