CODEWITHSUNDEEP
phpsql
horsy
horsy

Reputation: 1

delete duplicates

Is it possible to delete just one column in a table when display out?

company name ||  name || year||
____________________________________
walmart      || jason || 1990
___________________________________
walmart      || mary  || 2000

to

company name ||  name || year||
____________________________________
walmart      || jason || 1990
___________________________________
             || mary  || 2000
____________________________________

the data is retrieved from database.

Upvotes: 0

Views: 210

Answers (2)

Disillusioned
Disillusioned

Reputation: 14832

There are many ways to achieve this in SQL, but that's the wrong place to do do.
This is also a typical feature of reporting tools.

Upvotes: 0

Mladen Prajdic
Mladen Prajdic

Reputation: 15677

you'll have to do this on the client side.
something like
while CurrentValue == PreviousValue write empty string.

Upvotes: 6

Related Questions