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 the left table in sql?

911

Can we commit in trigger?

920

what is “go” in t-sql? : Transact sql

1038

how is myisam table stored? : Sql dba

996

What are the packages in pl sql?

965

Can you inner join the same table?

932

what are set operators in sql? : Sql dba

982

Explain the steps needed to create the scheduled job?

965

What do you understand by pl/sql records?

959

What do you mean by stored procedures?

950

How do you update a sql procedure?

970

What are triggers and its uses?

998

How sql query is executed?

1064

What is pl sql variable?

934

What is the difference between view and stored procedure?

909