how do i get latest transaction from sql database. All the records is saved in sql database and i use different application to grab the data from sql base on transaction. I use SELECT statement but i don't know how to make it unique variable/ID. 1st user might have 5 records and 2nd user 10 records and 3rd user 5 records and so on. How can i use SELECT statement to grab this record based on the transaction.
how do i create unique variable to define different transaction in sql select statement.
Please guide me !!!