How to produce two column that will not repeat the data

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

jemz

307

How to produce two column that will not repeat the data