Topics Topics Help/Instructions Help Edit Profile Profile Member List Register Paatha Gnyapakaalu - Archives from Old DB  
Search New Posts 1 | 2 | 8 Hours Search New Posts 1 | 3 | 7 Days Search Search Tree View Tree View Latest tweets Live Tweets
Bewarse Talk Discussion Board * Archives - 2011 * Cine Talk - Reviews, Gossips, Insider Info etc. * Archive through November 05, 2011 * SQL Query Help < Previous Next >

Author Message
Top of pagePrevious messageNext messageBottom of page Link to this message

Ravanabrahma
Mudiripoyina Bewarse
Username: Ravanabrahma

Post Number: 17583
Registered: 06-2004
Posted From: 98.151.191.253

Rating: N/A
Votes: 0 (Vote!)

Posted on Thursday, November 03, 2011 - 2:55 pm:    Edit Post Delete Post View Post/Check IP
Kubang:

aayanaki mohamatam ekkuva, naa a/c eyyi septha. details ampana?



MOVIEART--dv.exp1
Top of pagePrevious messageNext messageBottom of page Link to this message

Pokiri1
Mudiripoyina Bewarse
Username: Pokiri1

Post Number: 18288
Registered: 03-2006
Posted From: 192.35.35.34

Rating: N/A
Votes: 0 (Vote!)

Posted on Thursday, November 03, 2011 - 2:41 pm:    Edit Post Delete Post View Post/Check IP
hemu vall employer ki email pampadu anta $10per increase cheyamani.
ara nimashamulo sachevadivi nee address naku endhuku raa
Top of pagePrevious messageNext messageBottom of page Link to this message

Kubang
Pilla Bewarse
Username: Kubang

Post Number: 543
Registered: 09-2011
Posted From: 66.244.207.150

Rating: N/A
Votes: 0 (Vote!)

Posted on Thursday, November 03, 2011 - 2:36 pm:    Edit Post Delete Post View Post/Check IP
Ravanabrahma:

annai vapukunte everymonth vestha



aayanaki mohamatam ekkuva, naa a/c eyyi septha. details ampana?
Devuda, be ready
Top of pagePrevious messageNext messageBottom of page Link to this message

Ravanabrahma
Mudiripoyina Bewarse
Username: Ravanabrahma

Post Number: 17582
Registered: 06-2004
Posted From: 98.151.191.253

Rating: N/A
Votes: 0 (Vote!)

Posted on Thursday, November 03, 2011 - 2:31 pm:    Edit Post Delete Post View Post/Check IP
Kubang:

you owe at least 10% of your salary to Manager saab, that's how I see it.



annai vapukunte everymonth vestha MOVIEART--bemmi.adi
Top of pagePrevious messageNext messageBottom of page Link to this message

Kubang
Pilla Bewarse
Username: Kubang

Post Number: 542
Registered: 09-2011
Posted From: 66.244.207.150

Rating: N/A
Votes: 0 (Vote!)

Posted on Thursday, November 03, 2011 - 2:22 pm:    Edit Post Delete Post View Post/Check IP
Ravanabrahma:



you owe at least 10% of your salary to Manager saab, that's how I see it.
Devuda, be ready
Top of pagePrevious messageNext messageBottom of page Link to this message

Ravanabrahma
Mudiripoyina Bewarse
Username: Ravanabrahma

Post Number: 17581
Registered: 06-2004
Posted From: 98.151.191.253

Rating: N/A
Votes: 0 (Vote!)

Posted on Thursday, November 03, 2011 - 2:16 pm:    Edit Post Delete Post View Post/Check IP
Penkonda_tiger:

Bemmi .. thats what i meant .. it will work .. Inner select with rank



thanks annai..its working :-)
Top of pagePrevious messageNext messageBottom of page Link to this message

Ravanabrahma
Mudiripoyina Bewarse
Username: Ravanabrahma

Post Number: 17580
Registered: 06-2004
Posted From: 98.151.191.253

Rating: N/A
Votes: 0 (Vote!)

Posted on Thursday, November 03, 2011 - 2:16 pm:    Edit Post Delete Post View Post/Check IP
Penkonda_tiger:

use Rank() , order by the date in descending and get only those records who have rank 1



Thanks annai..it works
Top of pagePrevious messageNext messageBottom of page Link to this message

Penkonda_tiger
Yavvanam Kaatesina Bewarse
Username: Penkonda_tiger

Post Number: 6428
Registered: 06-2005
Posted From: 82.157.134.169

Rating: N/A
Votes: 0 (Vote!)

Posted on Thursday, November 03, 2011 - 2:11 pm:    Edit Post Delete Post View Post/Check IP
Ravanabrahma:

aagu chostha work avuthundemo



Bemmi .. thats what i meant .. it will work .. Inner select with rank
kanapade nijam: Good manners , kanapadanidhi: abusive language
Top of pagePrevious messageNext messageBottom of page Link to this message

Ravanabrahma
Mudiripoyina Bewarse
Username: Ravanabrahma

Post Number: 17579
Registered: 06-2004
Posted From: 98.151.191.253

Rating: N/A
Votes: 0 (Vote!)

Posted on Thursday, November 03, 2011 - 2:06 pm:    Edit Post Delete Post View Post/Check IP
Dobbey:

max(rownum) vaadochemo



antee vere rows koda untay ga mama...vere idea vachindi..select lo rank select chesi paina malla inkoka select padesi where rank =1 anta..aagu chostha work avuthundemo
Top of pagePrevious messageNext messageBottom of page Link to this message

Dobbey
Kurra Bewarse
Username: Dobbey

Post Number: 3625
Registered: 03-2011
Posted From: 65.204.218.243

Rating: N/A
Votes: 0 (Vote!)

Posted on Thursday, November 03, 2011 - 2:03 pm:    Edit Post Delete Post View Post/Check IP
max(rownum) vaadochemo MOVIEART--bemmi.adi
Health is Happiness
Top of pagePrevious messageNext messageBottom of page Link to this message

Ravanabrahma
Mudiripoyina Bewarse
Username: Ravanabrahma

Post Number: 17577
Registered: 06-2004
Posted From: 98.151.191.253

Rating: N/A
Votes: 0 (Vote!)

Posted on Thursday, November 03, 2011 - 1:44 pm:    Edit Post Delete Post View Post/Check IP
rank function ni where lo pedithe window functions not allowed antundi annai?
Top of pagePrevious messageNext messageBottom of page Link to this message

Ravanabrahma
Mudiripoyina Bewarse
Username: Ravanabrahma

Post Number: 17575
Registered: 06-2004
Posted From: 98.151.191.253

Rating: N/A
Votes: 0 (Vote!)

Posted on Thursday, November 03, 2011 - 1:31 pm:    Edit Post Delete Post View Post/Check IP
Ravanabrahma:



nitho mogudu thread lo veyyaboyi ikkada vesa annai..vere issue fix chesi test chesthunna..adi avvagane rank test chestha..
Top of pagePrevious messageNext messageBottom of page Link to this message

Penkonda_tiger
Yavvanam Kaatesina Bewarse
Username: Penkonda_tiger

Post Number: 6427
Registered: 06-2005
Posted From: 82.157.134.169

Rating: N/A
Votes: 0 (Vote!)

Posted on Thursday, November 03, 2011 - 1:30 pm:    Edit Post Delete Post View Post/Check IP
Bemmi why that Dance ?
kanapade nijam: Good manners , kanapadanidhi: abusive language
Top of pagePrevious messageNext messageBottom of page Link to this message

Ravanabrahma
Mudiripoyina Bewarse
Username: Ravanabrahma

Post Number: 17572
Registered: 06-2004
Posted From: 98.151.191.253

Rating: N/A
Votes: 0 (Vote!)

Posted on Thursday, November 03, 2011 - 1:22 pm:    Edit Post Delete Post View Post/Check IP
MOVIEART--thottigang
Top of pagePrevious messageNext messageBottom of page Link to this message

Nitho
Mudiripoyina Bewarse
Username: Nitho

Post Number: 19294
Registered: 12-2004
Posted From: 65.223.175.131

Rating: N/A
Votes: 0 (Vote!)

Posted on Thursday, November 03, 2011 - 1:20 pm:    Edit Post Delete Post View Post/Check IP
Ravanabrahma:



mahesh babu ki phone chesi adugu nee SQl doubts anni clear chestadu... twitter lo kottu
Jai Rajanna, Jai Jai Jagan anna
Top of pagePrevious messageNext messageBottom of page Link to this message

Ravanabrahma
Mudiripoyina Bewarse
Username: Ravanabrahma

Post Number: 17571
Registered: 06-2004
Posted From: 98.151.191.253

Rating: N/A
Votes: 0 (Vote!)

Posted on Thursday, November 03, 2011 - 1:17 pm:    Edit Post Delete Post View Post/Check IP
Penkonda_tiger:

Bemmi bedar is it only 2 records in the table or ?

use Rank() , order by the date in descending and get only those records who have rank 1



thanks annai..will do that..
Top of pagePrevious messageNext messageBottom of page Link to this message

Penkonda_tiger
Yavvanam Kaatesina Bewarse
Username: Penkonda_tiger

Post Number: 6424
Registered: 06-2005
Posted From: 82.157.134.169

Rating: N/A
Votes: 0 (Vote!)

Posted on Thursday, November 03, 2011 - 1:17 pm:    Edit Post Delete Post View Post/Check IP
Bemmi bedar is it only 2 records in the table or ?

use Rank() , order by the date in descending and get only those records who have rank 1
kanapade nijam: Good manners , kanapadanidhi: abusive language
Top of pagePrevious messageNext messageBottom of page Link to this message

Ravanabrahma
Mudiripoyina Bewarse
Username: Ravanabrahma

Post Number: 17569
Registered: 06-2004
Posted From: 98.151.191.253

Rating: N/A
Votes: 0 (Vote!)

Posted on Thursday, November 03, 2011 - 1:08 pm:    Edit Post Delete Post View Post/Check IP
Kubang:

nee ishtamochinattu vichalavidiga vaaaduko, evadanna addosthe cheppu. nenu soosukunta



google lo sootha trying sethanna..manollu quick ans istharani esa...MOVIEART--bemmi.angry
Top of pagePrevious messageNext messageBottom of page Link to this message

Kubang
Pilla Bewarse
Username: Kubang

Post Number: 539
Registered: 09-2011
Posted From: 66.244.207.150

Rating: N/A
Votes: 0 (Vote!)

Posted on Thursday, November 03, 2011 - 1:04 pm:    Edit Post Delete Post View Post/Check IP
Ravanabrahma:

max ni ela vadali



nee ishtamochinattu vichalavidiga vaaaduko, evadanna addosthe cheppu. nenu soosukuntaCLIPART--lol2
Devuda, be ready
Top of pagePrevious messageNext messageBottom of page Link to this message

Ravanabrahma
Mudiripoyina Bewarse
Username: Ravanabrahma

Post Number: 17568
Registered: 06-2004
Posted From: 98.151.191.253

Rating: N/A
Votes: 0 (Vote!)

Posted on Thursday, November 03, 2011 - 12:55 pm:    Edit Post Delete Post View Post/Check IP
I have a table where two rows are similar except run_date. I want to get the row which has the maximum run_date between those 2 rows. max ni ela vadali?

Topics | Last Hour | Last Day | Last Week | Tree View | Search | Help/Instructions | Program Credits Administration