150bryant Posted July 3, 2013 Report Posted July 3, 2013 [quote name='cherlapalli_jailer' timestamp='1372874999' post='1303916424'] select "fields" from tbl group by fileds having count > 1 then delete anthe gada ..what is other way? [/quote] select distinct (ids) from table will do as well
cherlapalli_jailer Posted July 3, 2013 Author Report Posted July 3, 2013 [quote name='BathiBottleBisket' timestamp='1372875131' post='1303916444'] select distinct (ids) from table will do as well [/quote] id 1 1 2 3 4 4 4 then we 1,2,3,4 even single record also will come right? we cannot eliminate based on it
150bryant Posted July 3, 2013 Report Posted July 3, 2013 [quote name='cherlapalli_jailer' timestamp='1372875293' post='1303916458'] id 1 1 2 3 4 4 4 then we 1,2,3,4 even single record also will come right? we cannot eliminate based on it [/quote] question is abt how to eliminate duplicates for tht column.. dont think abt the data associated with it.. if you are pulling data associated with it...then there will be more filter conditions to make things unique
tom bhayya Posted July 3, 2013 Report Posted July 3, 2013 [quote name='Brahmanandam_AFDB' timestamp='1372875712' post='1303916504'] Asalu E T L ante enti... [/quote]
cherlapalli_jailer Posted July 3, 2013 Author Report Posted July 3, 2013 [quote name='BathiBottleBisket' timestamp='1372875683' post='1303916498'] question is abt how to eliminate duplicates for tht column.. dont think abt the data associated with it.. if you are pulling data associated with it...then there will be more filter conditions to make things unique [/quote] k thank you more questions pl
Anta Assamey Posted July 3, 2013 Report Posted July 3, 2013 [quote name='Alexander' timestamp='1372875821' post='1303916529'] [/quote] Naa knowledge ki question valid ee kada....[img]http://i47.tinypic.com/4s086h.gif[/img]
cherlapalli_jailer Posted July 5, 2013 Author Report Posted July 5, 2013 LTT for more questions [img]http://i47.tinypic.com/4s086h.gif[/img]
ICANWIN Posted July 5, 2013 Report Posted July 5, 2013 [quote name='Brahmanandam_AFDB' timestamp='1372875712' post='1303916504'] Asalu E T L ante enti... [/quote] Extract Transform Load..
Anta Assamey Posted July 5, 2013 Report Posted July 5, 2013 [quote name='ICANWIN' timestamp='1373050598' post='1303922938'] Extract Transform Load.. [/quote] Neeku okkadike ardam ayyindi.... naaku nijamgane adhi ento teliyadu ani...[color=#282828][font=helvetica, arial, sans-serif][img]http://i47.tinypic.com/4s086h.gif[/img][/font][/color][color=#282828][font=helvetica, arial, sans-serif] [/font][/color]
ICANWIN Posted July 5, 2013 Report Posted July 5, 2013 [quote name='Brahmanandam_AFDB' timestamp='1373053528' post='1303923144'] Neeku okkadike ardam ayyindi.... naaku nijamgane adhi ento teliyadu ani...[color=#282828][font=helvetica, arial, sans-serif][img]http://i47.tinypic.com/4s086h.gif[/img][/font][/color][color=#282828][font=helvetica, arial, sans-serif] [/font][/color] [/quote] serious oo sarcasm oo teledu kani bro enno full forms telekunda enno vatini manam vadutune untam alane adigav anukunna...no offence
Anta Assamey Posted July 5, 2013 Report Posted July 5, 2013 [quote name='ICANWIN' timestamp='1373054516' post='1303923193'] serious oo sarcasm oo teledu kani bro enno full forms telekunda enno vatini manam vadutune untam alane adigav anukunna...no offence [/quote] NIjam ga ne cheppanu.... Naaku teliyadu.. Nenu Biotec background so eppudu vinanu kuda vinaledu... [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)][img]http://i47.tinypic.com/4s086h.gif[/img][/background][/size][/font][/color][color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)] [/background][/size][/font][/color]
Recommended Posts