topic Re: SELECT COUNT() vs. SELECT SINGLE COUNT() in Application Development and Automation Discussions

SELECT COUNT() vs. SELECT SINGLE COUNT()

alejiandro_sensejl — Mon, 19 Jul 2010 06:43:41 GMT

Hello gurus,

I simply want to check if at least one records of given where-clause already exists. Is there a difference between above mentioned statements?

Regards,

Alej

Re: SELECT COUNT() vs. SELECT SINGLE COUNT()

Former Member — Mon, 19 Jul 2010 07:05:17 GMT

the correct solution is SELECT f1 UP TO 1 ROWS !!!!

You should not use COUNT(*), at least on some databases it will count all records fulfilling the condition.

YOU should not use SINGLE, because ... search top entries there are endless discussion on UP TO 1 ROWS and SINGLE

Re: SELECT COUNT() vs. SELECT SINGLE COUNT()

alejiandro_sensejl — Mon, 19 Jul 2010 08:40:25 GMT

Hello Siegfried,

thanks for your quick reply.

Could you provide some links to official documentation to prove these theses? I already searched, but I could finded any references to your assumptions.

Thanks in advance and best regards,

Alej

Re: SELECT COUNT() vs. SELECT SINGLE COUNT()

Former Member — Mon, 19 Jul 2010 11:54:58 GMT

there is nothing officially published by SAP.

But my word should be enough , see here

http://www.dpunkt.de/suche/ergebnis?modus=einfach&author=&title=&keyword=boes

There you find source with exercise programs, run test case No. 381 and 382. I do not comment on the DB platforms but

I tried the 4 major ones.

Siegfried

topic Re: SELECT COUNT(*) vs. SELECT SINGLE COUNT(*) in Application Development and Automation Discussions

SELECT COUNT(*) vs. SELECT SINGLE COUNT(*)

Re: SELECT COUNT(*) vs. SELECT SINGLE COUNT(*)

Re: SELECT COUNT(*) vs. SELECT SINGLE COUNT(*)

Re: SELECT COUNT(*) vs. SELECT SINGLE COUNT(*)

topic Re: SELECT COUNT() vs. SELECT SINGLE COUNT() in Application Development and Automation Discussions

SELECT COUNT() vs. SELECT SINGLE COUNT()

Re: SELECT COUNT() vs. SELECT SINGLE COUNT()

Re: SELECT COUNT() vs. SELECT SINGLE COUNT()

Re: SELECT COUNT() vs. SELECT SINGLE COUNT()