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

Can we use distinct and group by together?

1052

How to convert comma separated string to array in pl/sql?

1177

how to do backup entire database? : Transact sql

1143

What are the different type of joins in sql?

952

What is a stored procedure in sql with example?

1125

how to implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql dba

987

What is a rank in sql?

960

how to rename an existing column in a table? : Sql dba

1016

Which sorts rows in sql?

1016

What is AUTH_ID and AUTH_USER in pl/sql ?

2186

How exception handling is done in advance pl/sql?

979

What is the difference among union, minus and intersect?

999

how to create a test table in your mysql server? : Sql dba

1005

What is case function?

1037

What is denormalization in a database?

1052