| Author |
Message |
    
Nsk9876
Pilla Bewarse
Username: Nsk9876
Post Number: 393
Registered: 07-2010
Posted From: 198.204.141.208
Rating: N/A
Votes: 0 (Vote!) | | Posted on Friday, September 11, 2015 - 2:59 pm: |
|
anna..... perfect ga work ayyindii......... thanks a lott |
Vusirikai
Mudiripoyina Bewarse
Username: Vusirikai
Post Number: 10426
Registered: 10-2011
Posted From: 198.203.175.175
Rating: N/A
Votes: 0 (Vote!) | | Posted on Friday, September 11, 2015 - 2:07 pm: |
|
Sel tab1.ida,tab1.idb,Max(tab2.idate),Max(tab2.iamt)
from Tab1 inner join Tab2 On
Tab1.Ida=Tab2.ida
Group by 1,2
http://www.cooking-wonders.com/
|
Vusirikai
Mudiripoyina Bewarse
Username: Vusirikai
Post Number: 10425
Registered: 10-2011
Posted From: 198.203.175.175
Rating: N/A
Votes: 0 (Vote!) | | Posted on Friday, September 11, 2015 - 2:06 pm: |
|
Sel tab1.ida,tab1.idb,Max(tab2.iamt)
from Tab1 inner join Tab2 On
Tab1.Ida=Tab2.ida
Group by 1,2
http://www.cooking-wonders.com/
|
Nsk9876
Pilla Bewarse
Username: Nsk9876
Post Number: 392
Registered: 07-2010
Posted From: 198.204.133.208
Rating: N/A
Votes: 0 (Vote!) | | Posted on Friday, September 11, 2015 - 1:53 pm: |
|
tab1 lo ida, idb clumns vunnai
tab2 lo ida, idte, iamt clumns vunni
cinarrio 1
ida, idb, max(idte) kavali
cinarrio 2
ida, idb, max(idte), max(iamt) kavali |
|
Archives - 2015