WG: help with an SQL....

it would be like:

select * from userlog_table where useraction=3Dlogin order by
field_for_ordering limit 10;



mit freundlichen Grüßen

Thomas Treffehn

Hans Brochier GmbH & Co KG

Abteilung S2 - Informationswesen
Marthastraße 16
90482 Nürnberg

Fon: +49 0911-9543-355
Fax: +49 0911-9543-383
www.brochier.de

----- Weitergeleitet von Thomas Treffehn/BROCHIER/DE am 17.08.2005 15:0=
1
-----
=

Mark Mchugh =


om> =
An
mysql list om>
17.08.2005 14:59 Ko=
pie
=

Th=
ema
help with an SQL.... =

=

=

=

=

=

=





Hi,
Hope somebody can help. I have a userlog table, and in
the table i have the following fields

id, userid,usertype,eventdate,useraction

so, i want to grab out the userid for the top 10 user
where useraction =3D login

can this be done with 1 sql statement?

thanks

MArk



__________________________________
Yahoo! Mail
Stay connected, organized, and protected. Take the tour:
http://tour.mail.yahoo.com/mailtour.html


--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Dtreffehn@brochi=
er.de
=



--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Dgcdmw-win32@m.gmane.org