Re: search for query that result one random url from domain

[Bernd Meier]

The Table contains one million urls with lets assume 500.000 domains

looks like first post: for example:

ID  URL                          Domain
1 http://www.google.de/example1 http://www.google.de
2 http://www.google.de/example2 http://www.google.de
3 http://www.google.de/example3 http://www.google.de
4 http://www.yahoo.de/example1 http://www.yahoo.de
5 http://www.yahoo.de/example1 http://www.yahoo.de
6 http://www.yahoo.de/example1 http://www.yahoo.de

now the result set should be:
3 http://www.google.de/example3 http://www.google.de
4 http://www.yahoo.de/example1 http://www.yahoo.de

or
6 http://www.yahoo.de/example1 http://www.yahoo.de
2 http://www.google.de/example2 http://www.google.de

just one URL from each Domain Group....

the query can be limited by 1000 Urls or 10.000 Urls...just as many as the user like to get....