Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: tommot82
  • Content: Threads
  • Order by date
  1. tommot82

    select intervals

    Hi, I am using a MSSQL database, and I am trying to select records from a db based on a 15 minute interval. The Date is recorded as a millisecond epoch time (stored as a numeric) which I round down to the nearest 15 minute window within the hour: SELECT ID, floor(rawdateandtime/900000)*900000...
  2. tommot82

    Select rows X-to Y

    Is there an easy way of returning specified rows that have no index column? I basically want to create a queries that only returns rows in blocks of 20 for example. any ideas?
  3. tommot82

    combingin two 'where' statements

    Is there any neat way i can combine the following two statements to return me a single table of results with the columns: lt2, lt3, id select count(*) lt2,id FROM TABLE where Value<2 GROUP BY id select count(*) lt3,id FROM TABLE where Value<3 GROUP BY id Thanks for your help tommot82

Part and Inventory Search

Back
Top