Select last 10 rows from the table

[EJ-Boy Perez]

Hi everyone1

May I ask assistance on how to select the last 10 rows from the table. table sorted in ascending order based on its column name or_date.

thank you in advance.

[Bodo Bergmann]

How about selecting the first 10 rows from the result set sorted in descending order,
then sorting those 10 rows ascending in the OpenROAD client using array.Sort() method?

Something like this (arr is an array of a user class for your result data):

 

  EXECUTE IMMEDIATE 'SELECT FIRST 10 or_date, col1, col2 FROM yourtable ORDER BY 1 DESC'

INTO :arr[i].or_date, :arr[i].col1, :arr[i].col2

  BEGIN

     i=i+1;

  END;
  COMMIT;

  arr.Sort(or_date = AS_ASC);

 

HTH.

Regards,

Bodo.

 

--

Bodo Bergmann

Senior Software Engineer

Actian | Engineering

Phone: +49.6103.3033.734

www.actian.com

 

GESELLSCHAFTSANGABEN: Geschäftsführer: Steven R. Springsteel, Stephen Mark Padgett, Markus Bockle

Sitz der Gesellschaft: Hamburg| Handelsregister: Amtsgericht Hamburg | HRB 135991| USt-IdNr: DE252449897

[pwhite peercore]

Hi EJ Boy,

It is a good question to question direct to the Ingres forums. Here are a couple of good places to visit.

http://lists.planetingres.org/mailman/listinfo/info-ingres
http://community.actian.com/forum/




This is my attempt:


* select count(*) from customer\g
Executing . . .
│ 3867│


* select cust_code from customer order by cust_code offset 3857\g
Executing . . .
│cust_cod│
│YESNADEX│
│YINBRAV0│
│YONDEVT0│
│YORRICV0│
│YOTFOOV0│
│YUMBRUV0│
│YUMCHIEX│
│ZHECHIEX│
│ZHKMELEX│
│ZHOZHOEX│
(10 rows)


I agree with Bodo's simple approach. Which ever you choose, be sure to test for table scans and locking issues. Run debug: qep, io trace and lock trace for your selected approach.

Paul

--
You received this message because you are subscribed to the Google Groups "OpenROAD Users Mailing List" group.
To unsubscribe from this group and stop receiving emails from it, send an email to openroad-user...@googlegroups.com.
To post to this group, send email to openroa...@googlegroups.com.
Visit this group at http://groups.google.com/group/openroad-users.
To view this discussion on the web visit https://groups.google.com/d/msgid/openroad-users/CO1PR06MB314F3A13D84338653234FED93280%40CO1PR06MB314.namprd06.prod.outlook.com.
For more options, visit https://groups.google.com/d/optout.

[EJ-Boy Perez]

Thank you everyone for the nice suggestions....