download free 30 days trial version buy simpledb explorer
Documentation   Download   Purchase   Support   FAQs    Forum    ScreenShots & Demos       

Sort Query

Support for SDBExplorer - A Simple Database Explorer for Amazon's SimpleDB

Sort Query

Postby tulip bang » Jun 25th, '10, 06:11

hello there,

I have thousands of records in my domain, I want to sort them on their title. How can I sort them?
Can you tell me the query syntax for sorting on item?

thanks..
Tulip.
tulip bang
 

Re: Sort Query

Postby Neelam Sharma » Jun 25th, '10, 14:11

Yes, you can sort items, SDB Explorer provides two way to sort items-
Option-1- Select the item from combo situated at middle panel, check asc if you want sorting in ascending order. If you do not select any item then it sort according to first attribute of table.
Option-2- You can give sort query & select your region of domain then click 'Run Query'.
Syntax of query - select * from domain-name where item-name is not null order by item-name asc.
Neelam Sharma
 
Posts: 16
Joined: Feb 17th, '10, 11:53


Return to Amazon SimpleDB

cron