Subject | Limit selection + firebird stability |
---|---|
Author | nk_111 |
Post date | 2002-05-25T09:09:50Z |
hello, I'm new comer in firebird 1.0. I have 2 questions:
1.
in MySql:
"select * from table_name limit 1,3"
in MSSql:
"select top 10 * from table_name"
what is the similar syntax in firebird? I've read Interbase6.0 SQL reference, but dont find answers there.
2.
how stable is firebird right now? both in Linux and Windows. this might be a silly question since there are references of
firebird users in ibphoenix.com. but, when I surf this mailinglist archieve for a while, there are topics about firebird crash
and some problem arises. so, i need another opinion or suggestion in which area firebird can/can't be used.
tia,
- nk -
1.
in MySql:
"select * from table_name limit 1,3"
in MSSql:
"select top 10 * from table_name"
what is the similar syntax in firebird? I've read Interbase6.0 SQL reference, but dont find answers there.
2.
how stable is firebird right now? both in Linux and Windows. this might be a silly question since there are references of
firebird users in ibphoenix.com. but, when I surf this mailinglist archieve for a while, there are topics about firebird crash
and some problem arises. so, i need another opinion or suggestion in which area firebird can/can't be used.
tia,
- nk -