meegu oka sql question.... wer r u?

[goli soda]

[quote author=INFATUATION link=topic=195931.msg2388157#msg2388157 date=1306252159]
not in function is de key.......dhani valla delete avachu....
[/quote][img]http://i147.photobucket.com/albums/r305/kishore_balu/Brahmi%20Gifs/brahmanandam39.gif[/img]

[Ranga_The_Donga]

[quote author=goli soda link=topic=195931.msg2388480#msg2388480 date=1306257400]
[img]http://i147.photobucket.com/albums/r305/kishore_balu/Brahmi%20Gifs/brahmanandam39.gif[/img]
[/quote] @3$% @3$% @3$% @3$%

em ayindhii...kaya ah pandu ah...??

[goli soda]

[quote author=INFATUATION link=topic=195931.msg2388574#msg2388574 date=1306258570]
@3$% @3$% @3$% @3$%

em ayindhii...kaya ah pandu ah...??
[/quote]inka try cheyya le mama...leopu vere urgent owkr ochindi adi chetshuna....

[Ranga_The_Donga]

[quote author=goli soda link=topic=195931.msg2388580#msg2388580 date=1306258605]
inka try cheyya le mama...leopu vere urgent owkr ochindi adi chetshuna....
[/quote]

vakay.....mallu meghs ni pilavadaniki manchi reason dhorikindhii....neeku... @3$% @3$% @3$% @3$%

[goli soda]

[quote author=INFATUATION link=topic=195931.msg2388604#msg2388604 date=1306258889]
vakay.....mallu meghs ni pilavadaniki manchi reason dhorikindhii....neeku... @3$% @3$% @3$% @3$%
[/quote]meegu is my frnd daa... thanni pilvataniki reason endhuku...

[Ranga_The_Donga]

[quote author=goli soda link=topic=195931.msg2388609#msg2388609 date=1306258950]
meegu is my frnd daa... thanni pilvataniki reason endhuku...
[/quote]

reason lekunda pilusthe bagodhani..... &D_@@ &D_@@ &D_@@

[goli soda]

[quote author=INFATUATION link=topic=195931.msg2388770#msg2388770 date=1306260816]
reason lekunda pilusthe bagodhani..... &D_@@ &D_@@ &D_@@
[/quote]malla ade maataa..meegu ni pilvataniki naku reason avsaram ledu.... [img]http://www.picasion.com/pic16/bba3376338eb74f83aaeab1e833e287f.gif[/img]

[manoghna]

[quote author=goli soda link=topic=195931.msg2388609#msg2388609 date=1306258950]
meegu is my frnd daa... thanni pilvataniki reason endhuku...
[/quote] @gr33d thankyou

[Ranga_The_Donga]

[quote author=goli soda link=topic=195931.msg2388780#msg2388780 date=1306260885]
malla ade maataa..meegu ni pilvataniki naku reason avsaram ledu.... [img]http://www.picasion.com/pic16/bba3376338eb74f83aaeab1e833e287f.gif[/img]
[/quote][img width=110 height=120]http://i147.photobucket.com/albums/r305/kishore_balu/Brahmi%20Gifs/brahmanandam39.gif[/img]

[Ranga_The_Donga]

[quote author=meghana9 link=topic=195931.msg2388787#msg2388787 date=1306260922]
@gr33d thankyou
[/quote]

abbo....inka appandi madam....evadanna frnd ane antadu....unknown ani anaduu.....!!!!

[goli soda]

[quote author=meghana9 link=topic=195931.msg2388787#msg2388787 date=1306260922]
@gr33d thankyou
[/quote][img]http://i51.tinypic.com/ix5ifq.jpg[/img]

[shah01]

select id,createdate from
(select id,createdate,rank() over(partition by id order by createdate desc) r1  from table)
where r1<>1;

This query will give you the duplicate records.

[galigannarao]

[quote author=shah01 link=topic=195931.msg2389862#msg2389862 date=1306280774]
select id,createdate from
(select id,createdate,rank() over(partition by id order by createdate desc) r1  from table)
where r1<>1;

This query will give you the duplicate records.
[/quote] you rock you rock you rock you rock

[king420]

nice thread

[Jambhalheart]

[quote author=goli soda link=topic=195931.msg2387727#msg2387727 date=1306247358]
I am having a table with 3 columns. Col1 is ID , Col2 is name and Col3 is create date. For some of the IDs there are multiple names. Now I have to delete those multiple names keeping the latest name from create date.Can you help me with the sql?
[/quote]



delete from emp where CREATEDATE not in (
select max(createdate) CREATEDATE from emp group by id)




nenu previous replies chudaledhu, may be they might have anwered already...