Jak znalezc powtarzajace sie rekordy?

Thread View: pl.comp.lang.delphi.bazy-danych

2 messages

[T] Back to Threads [V] Tree View [G] Group Articles

2 total messages Started by Pawel Koloszko Mon, 24 May 1999 13:09

#705

Author: Pawel Koloszko
Date: Mon, 24 May 1999 13:09

1 lines
849 bytes

Jakie zapytanie zwroci mi tylko takie rekordy, które sie powtarzaja ?

Re: Jak znalezc powtarzajace sie rekordy?

#706

Author: Tomasz Rubaj
Date: Mon, 24 May 1999 13:19

9 lines
886 bytes

Pawel Koloszko wrote:
> 
> Jakie zapytanie zwroci mi tylko takie rekordy, które sie powtarzaja ?
select * from tablica t1 where exists (select id, count(*) from tablica
t2 where t1.id=t2.id group by id having count(*)>1)

Pisane z pamieci. Nie bedzie dzialac szybko :)

TRubaj

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads