Subject select top row
What is the equivalent query in FireBird for the following MS SQL query
[ select top 1 * from users where name='name' ]
Thanks for any reply.