what is count(*) from po_vendors(any table)? what does it do
and
what is count(1) from po_vendors(any table)?
what is count(0) from po_vendors(any table)
the out put is same
what is the difference
- 4 Answers
- 10558 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / bujji
select count(*) from temp1;
select count(1) from temp1;
select count(0) from temp1;
Above all 3 statements gives count (all are same) including
null vaues.
select count(Column_Name) from temp1;
Above statement gives the coulumn count witout null vaues.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Do you know what is applysys in oracle application database schema, what is apps?
How can a process be deployed in soa?
what are the balancing segments in AR?
List of all the modules under Manufacturing, Finance and Distribution in oracle applications?
What is oracle soa suite?
Can you differentiate between mediator and osb?
Explain oracle apps architecture.
Hi any one plz help me .i need 2 or 3 customized and 2 or 3 development reports on PO module..if any body having plz send me with one by one step ,i mean where u do the customization and wht are the steps u follwed when u do the customization,wht are fields u added or deleted ,How u added or these fields as per clinet requirement and wht are errors u faced .plz send it to my mail id iamvenki@gmail.com
tell my any difficult situtation you solved in your experience in your company?
How is choreography different from orchestration?
What is instead of trigger in where we will use?
What do you understand by soa?
What are the different components of soa suite?
tell me the scenarios of the independent in reports
What do you understand by a set of books?
