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 to revise and re-run the last sql command?

1215

Write a sql query to get the third highest salary of an employee from employee_table?

1116

what is a database transaction? : Sql dba

1255

Should I use mbr or gpt?

1061

What is meant by temporal data?

1000

What is sql partition function?

1287

Explain how exception handling is done in advance pl/sql?

1044

What are the 3 types of behavioral triggers?

1311

What is a data definition language?

1195

Is t sql a programming language?

1111

Inline the values in PL/SQL, what does it mean.?

1273

How to get unique records from a table?

1021

what is the difference between sql and t-sql? : Transact sql

1135

What is the difference between a query and a report?

1053

What is cross join sql?

963