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

[goli soda]

[quote author=gerrard link=topic=195931.msg2387754#msg2387754 date=1306247630]
anthee 1st column repeat avuthundhaaa for diff names  sCo_^Y sCo_^Y
[/quote]yes...

[gerrard]

[quote author=goli soda link=topic=195931.msg2387752#msg2387752 date=1306247607]
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...
[/quote

so date batti sort chesi latest name matrame vundhi migatha names delete cheyyalaa  sCo_^Y sCo_^Y

[Ranga_The_Donga]

oka ID ki oka name cheyachu..

kani migatha names delete cheyali ante....ekkado kodathundhi...mat b ah names futurelo use chesukovachuga...okasari kanuko...

asala oka ID ki different names endhuku vachayi......

[goli soda]

[quote author=gerrard link=topic=195931.msg2387762#msg2387762 date=1306247714]
[quote author=goli soda link=topic=195931.msg2387752#msg2387752 date=1306247607]
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...
[/quote]

so date batti sort chesi latest name matrame vundhi migatha names delete cheyyalaa  sCo_^Y sCo_^Y
[/quote]

yeah

[goli soda]

[quote author=INFATUATION link=topic=195931.msg2387764#msg2387764 date=1306247769]
oka ID ki oka name cheyachu..

kani migatha names delete cheyali ante....ekkado kodathundhi...mat b ah names futurelo use chesukovachuga...okasari kanuko...

asala oka ID ki different names endhuku vachayi......
[/quote][img]http://www.desigifs.com/sites/default/files/ali_style4_0.gif?1290346395[/img]
aa names ki vere table undhi..... req marchaku..... itlanee cheyyali... migration vallu edo teda chesthe ila multiple ochayi....

[Ranga_The_Donga]

[quote author=goli soda link=topic=195931.msg2387774#msg2387774 date=1306247931]
[img]http://www.desigifs.com/sites/default/files/ali_style4_0.gif?1290346395[/img]
aa names ki vere table undhi..... req marchaku..... itlanee cheyyali... migration vallu edo teda chesthe ila multiple ochayi....
[/quote]

okie....suppose....oka date teesuko....18th ani...ah date na 5 members register ayyaru anuko.....
ante 1 ID ki 5 names vunnayani anuko
ela sort out cheyochu...can i use datetime...??

[galigannarao]

gimme 10 mins mama i will give you tthe query

[goli soda]

[quote author=INFATUATION link=topic=195931.msg2387785#msg2387785 date=1306248147]
okie....suppose....oka date teesuko....18th ani...ah date na 5 members register ayyaru anuko.....
ante 1 ID ki 5 names vunnayani anuko
ela sort out cheyochu...can i use datetime...??
[/quote]yeah date time vadochu.....

[galigannarao]

select * from <Table>where CreatedDate != (select MAX(CreatedDate) from <Table> where ID = 1) and id=1

idi select query baa. deentlo where condition nee delete queyki add cheyu

[Ranga_The_Donga]

select ID, distinct(Names),createdate from table

where createdate=(select max(createdate) from table)


idhi run chesthe...result set ela vundho cheppu........ sCo_^Y sCo_^Y

[The QUEEN]

sCo_^Y sCo_^Y  CITI#H@

[Pekatapaparao]

select  the  rows  order by  date      then delete manually  in query browser.

[goli soda]

[quote author=galigannarao link=topic=195931.msg2387837#msg2387837 date=1306248555]
select * from <Table>where CreatedDate != (select MAX(CreatedDate) from <Table> where ID = 1) and id=1

idi select query baa. deentlo where condition nee delete queyki add cheyu
[/quote]
idi okka ID ok baa..ala naku chala IDs unnayi...loop ayithe kastem baa chala sepu paduthundi....

[goli soda]

[quote author=INFATUATION link=topic=195931.msg2387842#msg2387842 date=1306248612]
select ID, distinct(Names),createdate from table

where createdate=(select max(createdate) from table)


idhi run chesthe...result set ela vundho cheppu........ sCo_^Y sCo_^Y
[/quote]
idi endhuku baa.... nenu anedi okkko ID ki....motham table lo max createdate endhuku?

[Ranga_The_Donga]

[quote author=goli soda link=topic=195931.msg2387916#msg2387916 date=1306249592]
idi endhuku baa.... nenu anedi okkko ID ki....motham table lo max createdate endhuku?
[/quote]

max(createdate) is for latest date ani.......