Home » SQL & PL/SQL » SQL & PL/SQL » how to remove redundant data
how to remove redundant data [message #609437] Thu, 06 March 2014 14:32 Go to next message
evivek
Messages: 6
Registered: December 2013
Location: mumbai
Junior Member

./fa/11747/0/


table
----------------
a b c
a null c
a h c
a null null
a null null

how to remove row2 row4 and row5 as these three are not giving any additional info which already given by row1 and row3
  • Attachment: Untitled.jpg
    (Size: 11.19KB, Downloaded 88 times)
Re: how to remove redundant data [message #609438 is a reply to message #609437] Thu, 06 March 2014 14:53 Go to previous message
BlackSwan
Messages: 22724
Registered: January 2009
Senior Member
SELECT col1, 
       col2, 
       col3 
FROM   table1 
WHERE  col1 IS NOT NULL 
        OR col2 IS NOT NULL 
        OR col3 IS NOT NULL; 


Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/

Previous Topic: Varchar2 Length
Next Topic: Validate data
Goto Forum:
  


Current Time: Mon Sep 01 15:06:32 CDT 2014

Total time taken to generate the page: 0.05985 seconds