Web SDK - Select data by field other than ID

Hi All,

I would like to select data by field other than ID. Can guide me how to do it? So far I can only get it by Id.

Also, how to get a list of items? for example select top 10 * from OEORDD where ORDUNIQ=1 will generate rows of result.

Thank you in advance.