Using LIMIT 1 does return me a single record but please note that the table can have multiple guids for which I need a unique record with all the digit types combined. Using LIMIT 1 returns me always one record. :-(
On 10/27/05, Abhishek <ajcool@gmail.com> wrote: > I am tryng to write a query which returns me a record like this <snip> > I do the query as this: > > select callguid , ( select digits from TABEL1 where type='a' ), ( select > digits from TABEL1 where type='b' ), ( select digits from TABEL1 where > type='c' ) from TABLE1; <snip> > Note that I get the records which i wanted, but I get them duplicated. If I > use 'distinct' keyword I get the desired result with no duplication. But > 'distinct' seems to be too expensive. > > Is there any better way I can do this without compromising the performance ?