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 a primary key have to be a number?

518

How do we accept inputs from user during runtime?

544

What is plpgsql language?

529

what is row? : Sql dba

705

what is an alias command? : Sql dba

544

what is user defined functions? : Sql dba

545

What is a trigger in sql?

634

how to do backup entire database? : Transact sql

612

What are the various levels of constraints?

659

Is pl sql different from sql?

530

How to change the order of columns in Oracle SQL Plus ?

610

How do I view an execution plan in sql?

525

What is sql and db2?

531

What is a sql statement?

529

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

607