Remove duplicate values

ai_zaviour · #1 (**permalink**) 01-21-12, 01:38

Hello everyone..

I have a problem with a query

What i need is, when i am displaying this result in jsp page, i want to show only one orders_id with other details, as follows,

Refer Result attachment

But this can't be taken with distinct,,

Plz help me out..

Im attaching what i have tried so far..

But no good with them..

r937 · #2 (**permalink**) 01-21-12, 08:22

you have indicated in your attachment that you want this --

Code:

order_id  products_id  products_model  products_name
  376        3006         GD0123       Gudrun: milk chocolates
  376        3020         4F0007       ODEL treats: Sri Lankan Delights - Jam
  376        3021         GD0123       ODEL treats: Sri Lankan Delights - Jam

to be shown like this --

Code:

order_id  products_id  products_model  products_name
  376        3006         GD0123       Gudrun: milk chocolates
             3020         4F0007       ODEL treats: Sri Lankan Delights - Jam
             3021         GD0123       ODEL treats: Sri Lankan Delights - Jam

this is something you should do with application logic, not with sql

Internet Services

Web Development

Digital Marketing

Consumer Tech