RE: FN-FORUM: MySQL

date posted 14th November 2007 11:33

Off the top of my head it is

SELECT PictureTypeID, PictureTypeDescription FROM PictureType LIMIT 10

MSSQL would be

SELECT TOP 10 PictureTypeID, PictureTypeDescription FROM PictureType

Regards
Sam Morgan
WiredEyes Media / ServWise Advanced Hosting

tel (Uk): +44 (0)20 7100 2178
tel (Italy): +39 070 773 6543
web : www.wiredeyes.com / www.servwise.com
----
umop ap!sdn w,! aw dlaH
----
----------------------------------------------------------------
Great Hosting Sale, 50% off all ServWise
hosting plans, use coupon code : HALFPRICE
----------------------------------------------------------------

> -----Original Message-----
> From: [EMAIL REMOVED] [EMAIL REMOVED] On Behalf Of Lists
> - ARKAD Solutions
> Sent: Wednesday, November 14, 2007 1:21 PM
> To: FN-FORUM / [EMAIL REMOVED]
> Subject: FN-FORUM: MySQL
>
>
> Morning all,
>
> Blonde day at the moment and I can't think of how to do this....
>
> How do I do select statement to get a specified number of records from
> a
> table.
>
> What I have so far is...
>
> SELECT PictureTypeID, PictureTypeDescription FROM PictureType
>
> I have a list of PictureTypeID Values...which is what I want to
> select..
>
> TIA
>
> Darren
>
>
>
> --
> Freelancers, contractors earn more with Prosperity4
> Call 0870 870 4414 or visit www.prosperity4.com
> and benefit from Inland Revenue approved expenses today.
>
> To advertise here: http://www.freelancers.net/advertising.html
>
>