Midhun Murali
Midhun Murali

Reputation: 2151

Last ItemName() in SimpleDB

I am trying to find the ITEMNAME() for the last item available in SimpleDB. I could n't find any resource which could guide me to get the result ? Is there any function or query available to get the last inserted item's name?

Upvotes: 1

Views: 76

Answers (1)

Ashish Pancholi
Ashish Pancholi

Reputation: 4659

If you are inserting itemName() is sequence or order then only you can get the last inserted itemName() by using the below query

select * from `domainname` where itemName() is not null order by itemName() desc limit 1

Upvotes: 1

Related Questions