What algorithm should i follow to retrieve data in the prescribed format?
Posted
by
Prateek
on Stack Overflow
See other posts from Stack Overflow
or by Prateek
Published on 2014-06-05T15:14:35Z
Indexed on
2014/06/05
15:24 UTC
Read the original article
Hit count: 288
I have to retrieve data from a database in which tables are consisting of fields like "ttc, rm, atc and lta" namely. Actually these values are stored on daily basis with a 15 min interval like
From_time to_time ttc rm atc lta
00:00 00:15 45 10 35 25,
00:15 00:30 35 10 25 25
and so on ..
These values are stored for every day of every month and i want it to be previewed in the prescribed format then what algorithm should i follow. I am confused about how to do comparisons for a format like below mentioned. The format is at this link
https://drive.google.com/a/itbhu.ac.in/file/d/0B_J0Ljq64i4Za2J1V0lvbDZ4eGc/edit?usp=sharing
To be specific once again, my question is, I have to prepare a report from the retrieved data which is being stored in the databases as explained above. But the report which is going to be prepared will be of entire month. So, to say the least, there may be cases that for two particular days the value of "ttc" would be same for some time so i want it to be listed together (as shown in format). And the confusing part is any of the values "ttc", "rm", "atc", "lta" can be same for any particular interval. So what algorithm should i follow for such comparisons.
And if still any query with question, u can ask your doubt.
Thanks
© Stack Overflow or respective owner