Comments by kiran0624

kiran0624 1-Jun-19 6:42am View

hmmm..
its don't need any environment to run code.
just copy code to index.html and open in browser.. this is basic.

kiran0624 1-Jun-19 6:05am View

Deleted

please try to run above the code..
their are 4 div id-citys..
its have to display in 3 div id-citys,
as 2 div id-city has to display in one id-city.

kiran0624 1-Jun-19 5:56am View

please try to run above the code..
their are 4 div id-citys..
its have to display in 3 div id-citys,
as 2 div id-city has to display in one id-city.

kiran0624 20-Apr-19 12:27pm View

before that i have tried this query

select b.aprl_fr_dt1, max(c.aprl_entdt)
from table_one a, table_two b, table_three c
where b.aprl_cmpcd='01' and b.aprl_flag='CNF' and b.aprl_status='ECNF'
and (b.aprl_fr_dt1 is not null or b.aprl_fr_dt1 !='')
and b.aprl_cmpcd =a.aprl_cmpcd
and b.aprl_flag=a.aprl_flag and b.aprl_status = a.aprl_status
and b.aprl_empcd= a.aprl_empcd and b.aprl_due_dt = a.aprl_due_dt
and b.aprl_empcd = c.aprl_empcd and b.aprl_cmpcd = c.aprl_cmpcd and b.aprl_due_dt = c.aprl_incdue
group by b.aprl_empcd, b.aprl_fr_dt1, b.aprl_to_dt1;

and successfully got required value, this value i'm trying to update into table_three to that id's(equal condition).

kiran0624 16-Dec-18 1:14am View

please give me an example, that could be help me!!!

kiran0624 15-Dec-18 4:40am View

i am working in spring and hibernate. there no problem in my java code as quick as quick result.
problem in SQL query.
we are using sql select alias to quick access from thousand of tables getting required columns in one query.
As same can we insert or update columns in 100 table in one query.

Comments by kiran0624 (Top 6 by date)