MystKnight Posted November 5, 2010 Share 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 Link to comment Share on other sites More sharing options...
Bowmore Posted November 5, 2010 Share 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 Link to comment Share on other sites More sharing options...
MystKnight Posted November 5, 2010 Author Share 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 Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now