Thread View: borland.public.interbase.sql
6 messages
6 total messages
Started by The DeerBear
Tue, 26 Nov 2002 11:49
[FB]Stored proc creation
Author: The DeerBear
Date: Tue, 26 Nov 2002 11:49
Date: Tue, 26 Nov 2002 11:49
21 lines
1355 bytes
1355 bytes
Hello, I have this problem: assume I have a table like this: 1) ID_Table 2) Value Now, say I want to select the THIRD value( that is, neither the first, nor the second, nor the fourth ). I can't imagine a SQL query that does this, but I think a SP would do the job. So, how can I create it? Do I need an UDF? How can I represent this situation in SQL? TIA for all the help you can give me Andrew
Re: [FB]Stored proc creation
Author: Bojidar Alexandrov
Date: Tue, 26 Nov 2002 14:05
Date: Tue, 26 Nov 2002 14:05
32 lines
1594 bytes
1594 bytes
The DeerBear wrote: > Hello, > > I have this problem: assume I have a table like this: > > 1) ID_Table > 2) Value > > Now, say I want to select the THIRD value( that is, neither the > first, nor the second, nor the > fourth ). > > I can't imagine a SQL query that does this, but I think a SP would do > the job. > > So, how can I create it? Do I need an UDF? > > How can I represent this situation in SQL? > > TIA for all the help you can give me > > Andrew There is something wrong with your design. Third by what order? Also whish interbase you use? -- Bojidar Alexanrov Kodar Ltd. http://www.Kodar.net
Re: [FB]Stored proc creation
Author: The DeerBear
Date: Tue, 26 Nov 2002 14:07
Date: Tue, 26 Nov 2002 14:07
15 lines
1323 bytes
1323 bytes
Bojidar Alexandrov wrote: > There is something wrong with your design. I can't tell my boss that :P > Third by what order? Third record, that is - knowing the correct ID_Table, I want the third record associated to that ID_Table value. > Also whish interbase you use? I use FireBird( as stated in the subject ) Andrew
Re: [FB]Stored proc creation
Author: Bojidar Alexandrov
Date: Tue, 26 Nov 2002 15:14
Date: Tue, 26 Nov 2002 15:14
29 lines
1641 bytes
1641 bytes
The DeerBear wrote: > Bojidar Alexandrov wrote: >> There is something wrong with your design. > > I can't tell my boss that :P > >> Third by what order? > > Third record, that is - knowing the correct ID_Table, I want the third > record associated to that ID_Table value. > >> Also whish interbase you use? > > I use FireBird( as stated in the subject ) > > Andrew Firebird support is at: ib_support groups.yahoo.com and mirror at news://news.atkin.com Select first 1 skip 2 ID_Table, Value from table order by ID_TABLE -- Bojidar Alexanrov Kodar Ltd. http://www.Kodar.net
Re: [FB]Stored proc creation
Author: Bojidar Alexandrov
Date: Tue, 26 Nov 2002 15:15
Date: Tue, 26 Nov 2002 15:15
7 lines
1219 bytes
1219 bytes
The DeerBear wrote: > Bojidar Alexandrov wrote: >> There is something wrong with your design. > > I can't tell my boss that :P Are you sure that you have a boss???
Re: [FB]Stored proc creation
Author: The DeerBear
Date: Tue, 26 Nov 2002 15:18
Date: Tue, 26 Nov 2002 15:18
9 lines
1210 bytes
1210 bytes
Bojidar Alexandrov wrote: > The DeerBear wrote: >> I can't tell my boss that :P > > Are you sure that you have a boss??? Yes I am. Andrew
Thread Navigation
This is a paginated view of messages in the thread with full content displayed inline.
Messages are displayed in chronological order, with the original post highlighted in green.
Use pagination controls to navigate through all messages in large threads.
Back to All Threads