select count(1) from table. will return values without null values. count

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

Question Posted / brajesh kr.

Answer Posted / brajesh kr.

select count(1) from table. will return values without null
values. count(*) will return values aceept null also.

Is This Answer Correct ?

0 Yes

2 No

Please Help Members By Posting Answers For Below Questions

How can you load microsoft excel data into oracle? : aql loader

1155

What do you mean by stored procedures?

996

Can we use ddl commands in pl sql?

1136

Why function is used in sql?

925

What is a field in a database?

1047

How to pipe multiline string to isql?

998

What is the difference between join and natural join?

914

what are the differences between require and include, include_once and require_once? : Sql dba

1008

What operating systems are supported by oracle sql developer?

937

what is a view? : Sql dba

1066

What is the use of <> sql?

960

What is a sql schema used for?

1080

Explain the structure of pl/sql in brief.

1067

Can you selectively load only those records that you need? : aql loader

1023

What is a table partition?

1106