Tracer Study dan Alumni

Universitas Widya Gama Mahakam Samarinda

Ini judul yang akan dimunculkan

Posted : 2019-09-13, View : 46 By : Admin PAUD

  • What do you want to happen if there is a row where some columns have NULL values and other columns have not NULL values? – Mark Byers Mar 12 '11 at 21:05

  • I would like to only get the values from the columns that are not null, and return only the column values in the row that are not null. Right now I use a loop to filter them out, is it possible to do that without a loop? – bryan sammon Mar 12 '11 at 21:08

  • 1

    @bryan - What is your table structure? Do all columns have the same datatype? – Martin Smith Mar 12 '11 at 21:10

  • 1

    @bryan - So what would your ideal result set look like then? A one column result set containing all the non null values? If not editing your question with example data and desired results would be helpful... – Martin Smith Mar 12 '11 at 21:15

  •  
  • 2

    @bryan - It sounds like your table may well have repeating groups across columns? (See the Wiki article for an explanation and a suggested alternative structure if that is the case en.wikipedia.org/wiki/First_normal_form)