Re: Random records

Article View: dk.edb.internet.webdesign.asp

Article #97

Back to dk.edb.internet.webdesign.asp Previous Next

#97

From: Chris
Date: Wed, 06 Nov 2002 06:46

19 lines
1200 bytes

On Thu, 31 Oct 2002 09:16:56 +0700, "utamachip" <uccom@cbn.net.id>
wrote:

>Dear all,
>
>Did any one know how to get some random records from a database using SQL
>syntax, that match several criteria.
>
>Thanks

Perhaps you mean something like this:

SELECT * FROM MYDATABASE WHERE FIRSTNAME='JOHN' AND LASTNAME='SMITH';

?

Hope this helps
-----
Chris

Technical Details

Message-ID: <3dc8bac7.6586724@news.telus.net>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-03!sn-xit-06!sn-xit-04!supernews.com!nntp.cs.ubc.ca!cyclone.bc.net!newsfeed.telusplanet.net!news0.telusplanet.net.POSTED!53ab2750!not-for-mail

References: <3dc09281$1@news.cbn.net.id>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff435,b9310e179d103e04
X-Google-Attributes: gidff435,public
X-Google-ArrivalTime: 2002-11-05 22:52:02 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-03!sn-xit-06!sn-xit-04!supernews.com!nntp.cs.ubc.ca!cyclone.bc.net!newsfeed.telusplanet.net!news0.telusplanet.net.POSTED!53ab2750!not-for-mail
From: chris2k01@hotmail.com (Chris)
Newsgroups: dk.edb.internet.webdesign.asp
Subject: Re: Random records
Message-ID: <3dc8bac7.6586724@news.telus.net>
References: <3dc09281$1@news.cbn.net.id>
X-Newsreader: Forte Free Agent 1.21/32.243
Lines: 19
Date: Wed, 06 Nov 2002 06:46:50 GMT
NNTP-Posting-Host: 142.173.104.17
X-Trace: news0.telusplanet.net 1036565210 142.173.104.17 (Tue, 05 Nov 2002 23:46:50 MST)
NNTP-Posting-Date: Tue, 05 Nov 2002 23:46:50 MST

Reply to Parent Message