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 is row level and column level indicator?
Draw a workflow diagram for this situation. If s3 is true session s4 and s5 should concurreently Run.if any one s4 or s5 true it should run s1.If s1 sucess it should execute s2 otherwise exit.can any one give me suggestion.Thanks in advance.
what is normalizer transformation?
What is the commit type if you have a transaction control transformation in the mapping?
Hi experts, For informatica developer, in real time, normally how much we use sql and plsql?
SRC1 -> EXP -> AGGR -> TGT SRC2 -> EXP -> Above is a maaping with two pipeline connected to the taret TGT. Design wise is this design is correct or not ?
What are the different threads in DTM process?
suppose a session is failed after a transformation , from where that session will run again , i.e . from beginning or from that transformation ?
What is source qualifier?
Explain how to import oracle sequence into informatica?
What is update strategy transform?
Name 4 output files that informatica server creates during session running?