select count(1) from emp? what is the o/p?
Answers were Sorted based on User's Feedback
Answer / chandu
count(1) means it will count based on 1st column in the
select statement
Is This Answer Correct ? | 14 Yes | 1 No |
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 |
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 |
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 |
What are the designer tools for creating transformations?
how to run workflow in unix?
5 Answers Colgate, HP, Tech Mahindra,
What is the actual work done in Development and in the production depts in building a datawarehouse. Which dept is more interesting and career oriented .
explain about session partitions ?
What is meant by query override?
i have f;latfile source. i have two targets t1,t2. i want to load the odd no.of records into t1 and even no.of recordds into t2.
How can i catch the Duplicate Rows From SorterTrans in a Seperate Target Table ?
Diffrence between static and dynamic cache
What are differences between Informatica 7.1 and 6.1
i have 1000 record flat file source i want 1st row to 1st target, 2nd row to 2nd target, 3rd row to 3rd target how will u do? Without using Mod Function? Explain....
What is event and what are the tasks related to it?
How to use Normalizer transformation?