V4MD Looking for ideas and solutions for searching double entries

[Ruslan Zasukhin]

on 10/2/03 1:36 PM, Florian Bogeschdorfer at fb at memedia.de wrote:

> I have tried some SQL searches which are not supported by Valentina.
> I am trying to find doubles, eg:
> 
> recID    name    forename
> 
> 1    Myers    Mike
> 2    Stone    Tom
> 3    Shields    Brooke
> 4    Stone    Tom
> 5    Myers    Mike
> 6    Willis    Bruce
> 
> I need as a result a cursor with records in order: 1,5,2,4
> 
> Any ideas?

Hi Florian,

I have CC this to Ivan.

Ivan, do you know how to solve this task for example on Oracle?
Using only SQL ?

It seems to me even in FULL SQL such task is quite not trivial
And will be executed in not effective way.

May be really consider this as special feature?

-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------