Information générale
Titre:
SQL - SELECT command
Hi all,
I have two problems:
1.)
I have table. From this table I want create cursor where get to all record in this cursor number for his position in cursor.
First record in cursor have "position" 1, second record in cursor have
"position" 2, ....
The "position" is new column in cursor.
How Can I solve this problem ?
2.)
How Can I create SELECT (cursor), where load only one record with specified position by ORDER item.
Example: I want get only 5th record from table ordered by "name" ("name" is index column in table)
Thanks.
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement