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

[goli soda]

#~` #~` #~`

[Chocolateboy]

nice thread

[Hitman]

#~` #~`

[chowdary9]

meghana okkate sql chadivinda  *7*^ *7*^ *7*^ *7*^ *7*^ *7*^

[galigannarao]

yem meegu ne adagala mamalni adaga koodada. ayna tanu evariko juniorki training istundi anta. apeesulo db open cheyatam kudaratle ani cheppindi. sare kani aa question ento adugu try chestam

[Chocolateboy]

[quote author=galigannarao link=topic=195931.msg2387716#msg2387716 date=1306247266]
yem meegu ne adagala mamalni adaga koodada. ayna tanu evariko juniorki training istundi anta. apeesulo db open cheyatam kudaratle ani cheppindi. sare kani aa question ento adugu try chestam
[/quote] CITI_$D# CITI_$D#

[goli soda]

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?

[jimcarrey]

SQL* from EMP
SQL* from DEPT


F@#da F@#da F@#da F@#da F@#da F@#da F@#da F@#da

[gerrard]

[quote author=Tom Sawyer link=topic=195931.msg2387730#msg2387730 date=1306247368]
SQL* from EMP
SQL* from DEPT


F@#da F@#da F@#da F@#da F@#da F@#da F@#da F@#da
[/quote]

  CITI_c$y CITI_c$y CITI_c$y CITI_c$y CITI_c$y

[galigannarao]

[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]ante id columnlo repeated data untada sCo_^Y

[goli soda]

guysssss you must be crazyyyy this is not spamming thread....  Dr@w@ Dr@w@ Dr@w@ };_ };_ };_

[galigannarao]

[quote author=goli soda link=topic=195931.msg2387747#msg2387747 date=1306247532]
guysssss you must be crazyyyy this is not spamming thread....  Dr@w@ Dr@w@ Dr@w@ };_ };_ };_
[/quote]sarele req clearga cheppu. id pass chesi daniki multiple names unte latest name unchi migtavi delete cheyyala. enti asalu

[goli soda]

[quote author=galigannarao link=topic=195931.msg2387742#msg2387742 date=1306247489]
ante id columnlo repeated data untada sCo_^Y
[/quote]
yes same ID malla malla repeat ayyyi diff names unnayi.... ippudu nenu aa ID name delete cheyyali keeping the lastes name..ante okko ID ki okko name undali...

[gerrard]

[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]

anthee 1st column repeat avuthundhaaa for diff names  sCo_^Y sCo_^Y

[goli soda]

[quote author=galigannarao link=topic=195931.msg2387750#msg2387750 date=1306247589]
sarele req clearga cheppu. id pass chesi daniki multiple names unte latest name unchi migtavi delete cheyyala. enti asalu
[/quote]yeah anthe nuvvu chepindhi correct...