Vote count:
0
Hi can I ask some help how can I produce this lat, lng ?
I tried this code but it keeps repeating the lat,lng values
SELECT h.*, d.* from
stdtbl h
inner
join (
select std_dtl_id,lat,lng, count(*) total
from stdtbl_detail group by std_dtl_id
) d
on h.id = d.std_dtl_id
inner join stdtbl_detail dt on h.id = dt.std_dtl_id
where
h.loginid = '1' AND h.stdid='013777'
How can I output like this
id stdid loginid std_dtl_id lat lng total
372 013777 1 372 51.507407 -0.127753 4
372 013777 1 372 51.507384 -0.127636 4
372 013777 1 372 51.507332 -0.127839 4
372 013777 1 372 51.507304 -0.127703 4
373 013777 1 373 40.764442 -73.923469 4
373 013777 1 373 40.764416 -73.923329 4
373 013777 1 373 40.764346 -73.923557 4
373 013777 1 373 40.764299 -73.923432 4
here is the demo http://ift.tt/1HKDLlV
Thank you in advance.
asked 25 secs ago
How to produce two column that will not repeat the data
Aucun commentaire:
Enregistrer un commentaire