Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 11991 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
What is oracle soa suite?
please send me forms, xml pulisher questions,answers
how do you describe O2C along with tables
What is a value set? List its various types.
how can develope the po variance and po summary report? with tables mandatory columns and query please?
How do you register report in oracle apps?
Can you explain the difference between architecture followed in 10g & 11g?
Hi, Anybody please send me the Oracle APPS 1i technical interview questions (Real time) as wel as sample resume also?
Can you differentiate between mediator and osb?
Plz anybody send me Technical specification for AP Interface
testing tools?
What do you understand by a set of books?
If we have a repeated record in a table. But the repeated record how i can transfer from table to nested table?
How can you achieve loose coupling in soa framework?
WHAT IS CUSTOM VIEW AND CUSTOM COMPONENT?
