look back in SQL

by

Assume your name is named tablename, you may try this query:

SELECT customer_key
FROM (
    SELECT customer_key, max(order_date) as max_date
    FROM tablename group by customer_key
) a
WHERE a.max_date < (sysdate - 60);

More Related Contents:

  1. How to get percentages of maximum counts?
  2. Sql to select the rows and ignore the duplicate userid in SQL Server [closed]
  3. i want to update table multiple row using IN statement
  4. Can anyone help me to get the query to retrieve data like below [closed]
  5. Select first row in each GROUP BY group?
  6. Is there any rule of thumb to construct SQL query from a human-readable description?
  7. MySQL LIKE IN()?
  8. How to use RETURNING with ON CONFLICT in PostgreSQL?
  9. Optimal way to concatenate/aggregate strings
  10. How can I list the tables in a SQLite database file that was opened with ATTACH?
  11. How can I see the raw SQL queries Django is running?
  12. Maximum size for a SQL Server Query? IN clause? Is there a Better Approach [duplicate]
  13. Convert varchar into datetime in SQL Server
  14. Doing a WHERE .. IN subquery in Doctrine 2
  15. Case expressions in Access
  16. How do I count unique items in field in Access query?
  17. Fastest way to perform nested bulk inserts with scope_identity() usage?
  18. Can we use join for two different database tables?
  19. Drop all the tables, stored procedures, triggers, constraints and all the dependencies in one sql statement
  20. SQLite – ORDER BY RAND()
  21. How can I select from list of values in Oracle
  22. Why are logical reads for windowed aggregate functions so high?
  23. How to convert Rows to Columns in Oracle? [duplicate]
  24. SQL Keep getting error with ON UPDATE CASCADE
  25. Select corresponding to row from the same table SQL Server
  26. Upsert with a transaction
  27. Update rows in one table with data from another table based on one column in each being equal
  28. How to include excluded rows in RETURNING from INSERT … ON CONFLICT
  29. Display next event date
  30. Sql query for tree table

Leave a Comment