| Author |
Message |
    
Pokiri
Kurra Bewarse
Username: Pokiri
Post Number: 763
Registered: 08-2004
Posted From: 198.69.173.194
| | Posted on Wednesday, February 08, 2006 - 7:06 am: |    |
iyite OK. 
cinema bewarse. |
Gochi
Bewarse ke Bewarse!
Username: Gochi
Post Number: 15496
Registered: 07-2004
Posted From: 24.2.198.200
| | Posted on Tuesday, February 07, 2006 - 7:57 pm: | |
 nayakudu maama post soosi navvocchindhi pokiri maama....
G to the O to the O to the C, C to the H to the H to the I ,GOCHI thats what u say... |
Pokiri
Kurra Bewarse
Username: Pokiri
Post Number: 762
Registered: 08-2004
Posted From: 69.180.150.33
| | Posted on Tuesday, February 07, 2006 - 7:54 pm: | |
Enti Gochi mama
cinema bewarse. |
Gochi
Bewarse ke Bewarse!
Username: Gochi
Post Number: 15491
Registered: 07-2004
Posted From: 24.2.198.200
| | Posted on Tuesday, February 07, 2006 - 5:03 pm: | |
G to the O to the O to the C, C to the H to the H to the I ,GOCHI thats what u say... |
Pokiri
Kurra Bewarse
Username: Pokiri
Post Number: 761
Registered: 08-2004
Posted From: 198.69.173.194
| | Posted on Tuesday, February 07, 2006 - 3:12 pm: | |
>>>mama neevu table b ni top nunchi refer chesedi enti... from clause lo petti second SQL statement lo.. yemmatladuthunnavu mandu kotti vachhava lunch break lo>>>
kadu mama,
We have a module which generates, SQL statemanets like that. ( we do some psedu oo type calls to generate SQL.)
That module is generating such kind of statements.
it is worng. Took time to look in to Oracle reference manual.
Original generated statement oka pedda page size.
Normally i dont write plan SQL statements.
Now problem in some others module. Now i have to explan what I am doing in my psedo language code. 
>>>mandu kotti vachhava lunch break lo
varni.
neellu tagadaki ki time ledura ante, mandu okata.
first show ki janalu leru ante, 100 days function ekkada anntlu vundi nee pani.
cinema bewarse. |
Nayakudu
Bewarse
Username: Nayakudu
Post Number: 1049
Registered: 05-2005
Posted From: 129.188.33.222
| | Posted on Tuesday, February 07, 2006 - 2:35 pm: | |
mama neevu table b ni top nunchi refer chesedi enti... from clause lo petti second SQL statement lo.. yemmatladuthunnavu mandu kotti vachhava lunch break lo |
Pokiri
Kurra Bewarse
Username: Pokiri
Post Number: 760
Registered: 08-2004
Posted From: 198.69.173.194
| | Posted on Tuesday, February 07, 2006 - 2:31 pm: | |
cinema bewarse. |
Pokiri
Kurra Bewarse
Username: Pokiri
Post Number: 759
Registered: 08-2004
Posted From: 198.69.173.194
| | Posted on Tuesday, February 07, 2006 - 1:56 pm: | |
cinema bewarse. |
Pokiri
Kurra Bewarse
Username: Pokiri
Post Number: 758
Registered: 08-2004
Posted From: 198.69.173.194
| | Posted on Tuesday, February 07, 2006 - 1:45 pm: | |
SELECT a.code as Code, a.name as Name, count(b.Ncode)
FROM cdmaster a, nmmaster b
WHERE a.code = b.code
and a.status = 1
and b.status = 1
and b.Ncode <> 'a10'
and trunc(last_updated_date) <= trunc(sysdate-13)
group by a.code, a.name
UNION
SELECT a.code as Code, a.name as Name, count(b.Ncode)
FROM cdmaster a, nmmaster z
WHERE a.code = z.code
and a.status = 1
and b.status = 1 <=== I am refering table b from top stmt.
cinema bewarse. |
Pokiri
Kurra Bewarse
Username: Pokiri
Post Number: 757
Registered: 08-2004
Posted From: 198.69.173.194
| | Posted on Tuesday, February 07, 2006 - 1:36 pm: | |
following union statement is valid?
SELECT name,age FROM football f
UNION
SELECT name,age FROM baseball b
where ( f.name=b.name)
(Union just joins the results from two queries or we can refer 1st query table's in second one too? vice versa.)
cinema bewarse. |
Gochi
Bewarse ke Bewarse!
Username: Gochi
Post Number: 15481
Registered: 07-2004
Posted From: 162.136.192.1
| | Posted on Tuesday, February 07, 2006 - 11:45 am: | |
 naaku SPSS thelavadhu maama....kaavalante theareticalgaa statistics thelusu
G to the O to the O to the C, C to the H to the H to the I ,GOCHI thats what u say... |
Nayakudu
Bewarse
Username: Nayakudu
Post Number: 1043
Registered: 05-2005
Posted From: 129.188.33.222
| | Posted on Tuesday, February 07, 2006 - 11:37 am: | |
aa code chusi nenu ardham chesukovali.. work cheyyathi kadu |
Nayakudu
Bewarse
Username: Nayakudu
Post Number: 1042
Registered: 05-2005
Posted From: 129.188.33.222
| | Posted on Tuesday, February 07, 2006 - 11:36 am: | |
GOCHI mama
naku konchem SPSS help kavali.. aa client daggariki chala sarlu velthunna doubt doubt ani... bagotla.. hehehe
aggregate proc vundi kada mama
danilo break lo use chese columns malla calculated columns mathrame SPSS dataset lo store avuthaya.. migathavi store kava
fields
a
b
c
d
e
f
aggregate
break=a,b
/f=max(f)
anuko..
ippudo resultant set lo only a,b,f vuntaya leka cd kuda vuntaya |
Donga_evaru
Desanike Pedda Bewarse
Username: Donga_evaru
Post Number: 10798
Registered: 08-2004
Posted From: 134.93.44.21
| | Posted on Tuesday, February 07, 2006 - 11:32 am: | |
gosiga  |
Nayakudu
Bewarse
Username: Nayakudu
Post Number: 1038
Registered: 05-2005
Posted From: 129.188.33.222
| | Posted on Tuesday, February 07, 2006 - 11:22 am: | |
edo mama ala guddeddu chelo padinattu.. hehehe |
Gochi
Bewarse ke Bewarse!
Username: Gochi
Post Number: 15480
Registered: 07-2004
Posted From: 162.136.192.1
| | Posted on Tuesday, February 07, 2006 - 11:21 am: | |
 DEgaa...
G to the O to the O to the C, C to the H to the H to the I ,GOCHI thats what u say... |
Donga_evaru
Desanike Pedda Bewarse
Username: Donga_evaru
Post Number: 10797
Registered: 08-2004
Posted From: 134.93.44.21
| | Posted on Tuesday, February 07, 2006 - 11:18 am: | |
nayakudu mama, iragadhisavu 
gosiga..madhyalo table/colomns badhulu shakeelano, alphonsa no caling sesi vuntavu |
Hemanth
Bewarse ke Bewarse!
Username: Hemanth
Post Number: 12672
Registered: 03-2004
Posted From: 57.68.10.185
| | Posted on Tuesday, February 07, 2006 - 11:15 am: | |
weldone nayakudu mama.  |
Donga_evaru
Desanike Pedda Bewarse
Username: Donga_evaru
Post Number: 10796
Registered: 08-2004
Posted From: 134.93.44.21
| | Posted on Tuesday, February 07, 2006 - 11:14 am: | |
gosiga yentha yethuki yedhigipoyavu |
Gochi
Bewarse ke Bewarse!
Username: Gochi
Post Number: 15479
Registered: 07-2004
Posted From: 162.136.192.1
| | Posted on Tuesday, February 07, 2006 - 11:11 am: | |
thanx maama....work ayyindhi...anthaku mundu nenu ilaa sesthey enduku work avvaledantaav..
select account from test a
where etc etc
and not exists (select 'X' from test b
where b.account = a.account
and b.assign_date > a.assign_date)
G to the O to the O to the C, C to the H to the H to the I ,GOCHI thats what u say... |
Nayakudu
Bewarse
Username: Nayakudu
Post Number: 1033
Registered: 05-2005
Posted From: 129.188.33.222
| | Posted on Tuesday, February 07, 2006 - 11:04 am: | |
mama what is the unique column in the table.. please use that column in the join condition |
Hemanth
Bewarse ke Bewarse!
Username: Hemanth
Post Number: 12671
Registered: 03-2004
Posted From: 57.68.10.185
| | Posted on Tuesday, February 07, 2006 - 11:00 am: | |
ammani, bhale rasesthunnaru ga assala. |
Gochi
Bewarse ke Bewarse!
Username: Gochi
Post Number: 15478
Registered: 07-2004
Posted From: 162.136.192.1
| | Posted on Tuesday, February 07, 2006 - 10:59 am: | |
thanx maama....try sesi soottaa undu
G to the O to the O to the C, C to the H to the H to the I ,GOCHI thats what u say... |
Nayakudu
Bewarse
Username: Nayakudu
Post Number: 1032
Registered: 05-2005
Posted From: 129.188.33.222
| | Posted on Tuesday, February 07, 2006 - 10:57 am: | |
select distinct *
from test a
where a.date = (select max(b.date) from test b
where a.account = b.account) |
Nayakudu
Bewarse
Username: Nayakudu
Post Number: 1031
Registered: 05-2005
Posted From: 129.188.33.222
| | Posted on Tuesday, February 07, 2006 - 10:56 am: | |
assuming your table name is test
select *
from test a
where a.date = (select max(b.date) from test b
where a.account = b.account) |
Gochi
Bewarse ke Bewarse!
Username: Gochi
Post Number: 15477
Registered: 07-2004
Posted From: 162.136.192.1
| | Posted on Tuesday, February 07, 2006 - 10:46 am: | |
maammas...naakoka chinna problem vacchindhi...
oka table undhi...
account --- strategy ---assign_date
1-----45---------Jan 13,2005
1-----33-------- Jan 11,2005
1-----25-------- Dec 11,2005
2-----11--------etc etc
2-----41-------etc etc
ippudu naaku account and its latest strategy kaavali... like for account 1,45
G to the O to the O to the C, C to the H to the H to the I ,GOCHI thats what u say... |
