MystKnight 0 Posted November 5, 2010 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 Share this post Link to post Share on other sites
Bowmore 97 Posted November 5, 2010 (edited) 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 "Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the universe trying to build bigger and better idiots. So far, the universe is winning."- Rick Cook Share this post Link to post Share on other sites
MystKnight 0 Posted November 5, 2010 @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 Share this post Link to post Share on other sites