The Correct is
select first 1 *
from MyTable

--- ales <ales@...> escribió: > Helo!

>
> How can I select from one table and limit results to one record.
>
> select * from MyTable where MyTable.MyColumn = Something
>
> In MySQL I am using LIMIT 1 but in firebird it is not working.
>
> --
> Ale¹ :)
>
> + http://www.curk-sp.si
>
>
>
> ------------------------ Yahoo! Groups Sponsor
>
> To unsubscribe from this group, send an email to:
> firebird-support-unsubscribe@yahoogroups.com
>
>
>
> Your use of Yahoo! Groups is subject to
> http://docs.yahoo.com/info/terms/
>
>

=====
Jose S. Romero
Advanced Systems - Soluciones Informáticas
Paraná - Entre Ríos - Argentina

------------
Internet GRATIS es Yahoo! Conexión
4004-1010 desde Buenos Aires. Usuario: yahoo; contraseña: yahoo
Más ciudades: http://conexion.yahoo.com.ar