Hii,
in a table there are two fields time, price. the data is stored in such a way that there are lots of data for a minute(max 60) i.e. for different seconds.
1-12.00.00
2-12.00.01
2.4-12.00.02
can i query it someway to get only 1 data for a minute, or 2 datas for a minute. i.e. i want data minute wise
in a table there are two fields time, price. the data is stored in such a way that there are lots of data for a minute(max 60) i.e. for different seconds.
1-12.00.00
2-12.00.01
2.4-12.00.02
can i query it someway to get only 1 data for a minute, or 2 datas for a minute. i.e. i want data minute wise