Posted By: Libb (Libor) on 'CZdatabases'
Title:     Re: zajimavost
Date:      Thu Sep  5 06:44:36 2002

select count(*) from B where id in (select distinct id from A)

Takhle bych to delal ja - pro MS SQL

> Ahoj.
> 
>   tab A                  tab B
>   id                     id
>   1                      1
>   1                      2
>   1                      3
>   2
>   2
> 
> A ted jak zjistit pocet zaznamu v B, ktere maji odkaz v tabulce A?
> 
>   SELECT COUNT(*) FROM a,b WHERE a.id = b.id 
> 
> vrati hodnotu 4. Nas sef nastesti nekde vyhrabal:
> 
>   SELECT COUNT(DISTINCT b.id) FROM a,b WHERE a.id = b.id
> 
> a to vrati 2 :-)  Je to Informix specific, nebo to funguje i jinde?
> Jovo.

                                                                      Libb




Search the boards