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 |
How can you access the remote source into your session?
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
What is the session task and command task?
How to delete duplicate records in a flat file source?
What is the scenario which compels informatica server to reject files?
what is INFORMATICA TESTING process
What are 2 modes of data movement in Informatica Server?
Two Default User groups created in the repository are ____ and ______
What is update strategy transform?
What is performance tuning in informatica. What measures you will take if some thing is taking much time in your process of ETL?
What is diff joiner and lookup
Can you please mail me a copy of Informatica Certification Exam dumps to r_balakrishna@yahoo.com