I am not very cool in SQL and I need help. I have query like "select distict a,b from c group by a,b" Response on this SQL query in TSM Server is: A1 B1 A1 B2 A2 B3 A2 B4 A2 B5 I would like to have: A1 B1 B2 A2 B3 B4 B5 I know exactly it is possible in Oracle SQL*Plus. Is it possible in TSM Server 5.5.3? Is it possible in TSM Server 6.1.2 (DB2)? What is the way, if possible?
Grigori G. Solonovitch Senior Technical Architect Information Technology Bank of Kuwait and Middle East http://www.bkme.com Phone: (+965) 2231-2274 Mobile: (+965) 99798073 E-Mail: g.solonovi...@bkme.com<mailto:g.solonovi...@bkme.com> Please consider the environment before printing this Email Please consider the environment before printing this Email. ________________________________ "This email message and any attachments transmitted with it may contain confidential and proprietary information, intended only for the named recipient(s). If you have received this message in error, or if you are not the named recipient(s), please delete this email after notifying the sender immediately. BKME cannot guarantee the integrity of this communication and accepts no liability for any damage caused by this email or its attachments due to viruses, any other defects, interception or unauthorized modification. The information, views, opinions and comments of this message are those of the individual and not necessarily endorsed by BKME."