|
|
Posted by Niel Darren on 01/26/07 09:00
Hi,
I am a total newbie with SQL-statements, but hope you can help me, i have a
few questions:
1. How can i get the number of rows/records in a table with a SQL statement
?
2. I have a record looking like this:
ID, TIMESTAMP (hh:mm:ss), datastring
Is it possible with a SQL-statement to for example extract all records
between one timestamp to another in that format or should i convert it into
a unixtimestamp instead for simplicity ?
3. Is it possible to do calculations ? i have another table with: ID,
TIMESTAMP, graph x-point value
Then i want to instruct it to extract from one time to another, and give
me the average of all theese values (only asking if i can do it with SQL, if
not i can do it with code ofcourse).
Do you have a link to a PDF or similar resource that is useful for a SQL
newbie so i could get an insight in SQL - as i said, i am not much into it.
Thanks alot.
Navigation:
[Reply to this message]
|