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

Does view contain data?

1024

What are dml commands?

1016

What is dense_rank?

931

What is sql engine in oracle?

984

In a distributed database system, can we execute two queries simultaneously?

1078

Is null operator in sql?

1023

Is sqlite good enough for production?

990

How do I edit a trigger in sql developer?

990

What is index example?

1000

how can we submit a form without a submit button? : Sql dba

982

How many subqueries can be nested in a statement?

979

What kind of join is join?

957

What is on delete restrict?

998

What does over partition by mean in sql?

970

Define join and name different types of joins?

998