SELECT *
FROM tbl_prop
WHERE tbl_prop.field_date >= getDate()-1
ORDER BY tbl_prop.field_date DESC
-----------------------------------------
This will help you show the latest 24 hrs data, you...
Type: Posts; User: talalmanaa; Keyword(s):
SELECT *
FROM tbl_prop
WHERE tbl_prop.field_date >= getDate()-1
ORDER BY tbl_prop.field_date DESC
-----------------------------------------
This will help you show the latest 24 hrs data, you...
I have two tables in SQL: tbl_names, and tbl_insert.
the field named: tbl_names.field_dictionary contains names.
the tbl_insert contains many fields and one of them is called...