Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Eagle_f90
Constraint Violating Yak Guru
424 Posts |
 Posted - 2004-07-02 : 17:43:10
|
| I am trying to help a friend with a select statment that is supposed to pull all the recodes that have a time stamp within the last 24 hours. There is a colum that keeps the time stamp in it. Here is what he has for the statment. But it is a little to complicated for me, can someone hel.SELECT DISTINCT $column_name, COUNT($column_name) AS c FROM $table_name GROUP BY column_name where tstamp > time() - 86400 ORDER BY c DESC LIMIT 100--For those with wings, fly to your dreamsDearms are what are found at the end of reality, and your reality if what is found at the end of your dreams. |
|
|
|
|
|
pulling records from MySQL