SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Display Column Value Once

NikkiJan 7 2013 — edited Jan 7 2013

Hey,
I am trying to only display a column value one time for a record, not a static value. The value changes and there can be many values. I do not think grouping will work since the Date value is dynamic. I am using Oracle for Toad 10.5. There are 4 records with this test data.

select Date, Person, Language, Country
from TableA

TableA
Date            Person  Language   Country
01/25/2013       James   English
12/20/2012       James   English
                                     US
                                     AF

Would like to only display

Date            Person  Language   Country
01/25/2013       James   English
12/20/2012  
                                     US
                                     AF

Thanks for reading this thread!

Edited by: Nikki on Jan 7, 2013 1:08 PM

This post has been answered by Frank Kulash on Jan 7 2013

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 4 2013

Added on Jan 7 2013

3 comments

879 views