how to return the lastest info using sql

i want to get the lastest info in the databse using sql ,

this is my datbase's table

what can i 开发者_如何学Godo ,

i want to get the last address_reality

the table's name is 'location'

thanks

---

You can use DESC in the SQL query to get the results in descending order from Database.

Then use this query if you are incrementing a primary key id.

String sql = "SELECT a.id,a.type,a.remark from  accounts_command_type  a WHERE a.response = '"
                + response + "' ORDER BY a.id DESC";

---

You will need to add one more column to the table which is primary key and autoincremented locationid for example. Then you can use below query.

SELECT TOP 1 address_reality from location order by locationid DESC