| List: | General Discussion | « Previous MessageNext Message » | |
| From: | Martijn Tonies | Date: | September 5 2007 2:17pm |
| Subject: | Re: Simple questio SQL | ||
| View as plain text | |||
> I have a Table and want to know the most visited products. > > > > Products > > - Id > > - Name > > - Visited > > > > Visited is numeric. How about: select * from Products order by Visited desc ? Martijn Tonies Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle & MS SQL Server Upscene Productions http://www.upscene.com My thoughts: http://blog.upscene.com/martijn/ Database development questions? Check the forum! http://www.databasedevelopmentforum.com
| Thread | ||
|---|---|---|
| • Simple questio SQL | Tomas Abad | 5 Sep |
| • Re: Simple questio SQL | Martijn Tonies | 5 Sep |
| • RE: Simple questio SQL | Jay Blanchard | 5 Sep |
| • Re: Simple questio SQL | Alex Arul Lurthu | 5 Sep |
| • RE: Simple questio SQL | Wm Mussatto | 5 Sep |