SELECT COUNT(1) FROM TAB RESULT IS 91

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

Question Posted / indrajeet kumar

Answer Posted / indrajeet kumar

SELECT COUNT(1) FROM TAB

RESULT IS 91

Is This Answer Correct ?

2 Yes

17 No

Please Help Members By Posting Answers For Below Questions

what is the difference between a having clause and a where clause? : Sql dba

1087

What are the different ways to optimize a sql query?

946

Can you skip header records while loading? : aql loader

1053

Which are sql * plus commands?

1130

What is pl/sql language case sensitive?

1127

Why we use triggers in mysql?

992

What is the difference between function and procedure in pl/sql?

1086

Is microsoft sql free?

1104

What is trigger types in sql?

992

explain the options of myisamchk to improve the performance of a table. : Sql dba

1010

Is left join faster than inner join?

1123

what are integrity rules?

1026

Do triggers have restrictions on the usage of large datatypes, such as long and long raw?

1166

how many sql ddl commands are supported by 'mysql'? : Sql dba

1023

Mention what plvcmt and plvrb does in pl/sql?

1143