select count(1) from emp? what is the o/p?

Categories >> Software >> Data Warehouse >> Informatica
Suggest New Category

Question Posted / mehul.thakur

5 Answers
10802 Views
TCS, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

select count(1) from emp? what is the o/p?..

Answer / chandu

count(1) means it will count based on 1st column in the
select statement

Is This Answer Correct ?

14 Yes

1 No

select count(1) from emp? what is the o/p?..

Answer / munni

count(1) will give the count of the numbr of records in the
table. count(1) is faster than count(*) since the count is
not based on all the fields.

Is This Answer Correct ?

13 Yes

1 No

select count(1) from emp? what is the o/p?..

Answer / moorthy g

select count(1) from emp;

Count(1):
14
It will display how many records in emp table
Total 14 Records are there in my table.
Correct If I'm wrong
Regards,
Moorthy

Is This Answer Correct ?

11 Yes

2 No

select count(1) from emp? what is the o/p?..

Answer / guest

all emp count will be displayed

Is This Answer Correct ?

1 Yes

1 No

select count(1) from emp? what is the o/p?..

Answer / ankur saini er.ankur861@gmail.

count(1) means it will count based on the first columnin
the table ..say first column is a_id and data ia

a_id a_nm
1 a
2 b
3 c
4 d
? e

so here count(1) will be =4 where as count(*) =5
so count(1) give the count for column 1 excluding nulls

Is This Answer Correct ?

0 Yes

1 No

Post New Answer