[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mysql-win32
Subject:    WG: help with an SQL....
From:       treffehn () brochier ! de
Date:       2005-08-17 13:05:39
Message-ID: OF8E1F96D9.6554C6D1-ONC1257060.00479909-C1257060.0047E010 () brochier ! de
[Download RAW message or body]





it would be like:

select * from userlog_table where useraction=login 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:01
-----
                                                                           
             Mark Mchugh                                                   
             <mark_mch@yahoo.c                                             
             om>                                                        An 
                                        mysql list <win32@lists.mysql.com> 
             17.08.2005 14:59                                        Kopie 
                                                                           
                                                                     Thema 
                                        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 = 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=treffehn@brochier.de



-- 
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe:    http://lists.mysql.com/win32?unsub=mysql-win32@progressive-comp.com


[prev in list] [next in list] [prev in thread] [next in thread]