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

what is a join? : Sql dba

561

What is the purpose of using pl/sql?

663

What is the least restrictive isolation level? : Transact sql

565

How do I truncate a sql log file?

532

What is query execution plan in sql?

564

What are pl sql data types?

549

What is count * in sql?

551

Can you select everything, but 1 or 2 fields, without writer's cramp?

495

How can we solve sql error: ora-00904: invalid identifier?

697

What is an emotional trigger?

516

What is sqlcontext?

549

Is progress software supports to ( pl/sql )?

528

Can we create a trigger on view?

487

Which is better cte or subquery?

540

Why is nosql good?

593