im using mysql 3.2 select distinct * from MY_TABLE; ---- doesnt work.. give me the entire content of table
select distinct from MY_TABLE;--- sql error John McNally <[EMAIL PROTECTED]> wrote: what database is this? and have you tried a select distinct * from MY_TABLE; does that return results? john mcnally Java Mails wrote: > > Hi guys... > I have a problem using setDistinct of criteria. Tho it doesnt throw any exception, >it doesnt seem to work either. > i just did a straightforward > Criteria c = new Criteria(); > c.setDistinct(); > > Vector v = myTablePeer.doSelect(c) > > am I missing out something here? It returns nothing(table contains data). > > can anyone be of help? > > --------------------------------- > Do You Yahoo!? > Yahoo! Tax Center - online filing with TurboTax -- To unsubscribe, e-mail: For additional commands, e-mail: --------------------------------- Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax
