SQL : Showing Last 5 Rows of a table

[MystKnight 0]

Hello

I'm totally noob to AutoIt. Ive been using it for a few weeks only but id like to say its really fun.

Now, i made my own exe without gui. Ive wanted to add gui to add records to my table and show last 5 rows in an order.

But i really have no idea what to use.

Any help is appreciated

[Bowmore 97]

 Depending on the database you are using one of these methods should work for getting the last 5 rows from the table.

SELECT *FROM 
 (SELECT * FROM my_table ORDER BY col_name_1)WHERE ROWNUM < 5;

SELECT *FROM my_table aWHERE 
 5 >= (SELECT COUNT(DISTINCT maxcol)       FROM my_table b       WHERE b.maxcol <= a.maxcol
ORDER BY maxcol;

Edited November 5, 2010 by Bowmore

[MystKnight 0]

@Bowmore

Thanks for trying to helping me. I'm good at writing querries. The problem is how do i create Table Apperance and set the values getting them from table and refreshing the values every minutes