SQL selecting rows by most recent date with two unique columns

by

You can use a GROUP BY to group items by type and id. Then you can use the MAX() Aggregate function to get the most recent service month. The below returns a result set with ChargeId, ChargeType, and MostRecentServiceMonth

SELECT
  CHARGEID,
  CHARGETYPE,
  MAX(SERVICEMONTH) AS "MostRecentServiceMonth"
FROM INVOICE
GROUP BY CHARGEID, CHARGETYPE

More Related Contents:

  1. The most efficient way to UPPER CASE two columns in a single query [closed]
  2. Current date in Oracle Db
  3. ORA-01843 Not a valid month
  4. Merging two tables in SQL [closed]
  5. I want to search job and salary from employee table but I am getting error like invalid relational operator [closed]
  6. How do I do top 1 in Oracle? [duplicate]
  7. Case insensitive searching in Oracle
  8. How to declare variable and use it in the same Oracle SQL script?
  9. How to find the employee with the second highest salary?
  10. Oracle: What does `(+)` do in a WHERE clause?
  11. Are a CASE statement and a DECODE equivalent?
  12. Concatenate results from a SQL query in Oracle
  13. format interval with to_char
  14. Oracle SQL – Identify sequential value ranges
  15. How to kill a running SELECT statement
  16. Equivalent function for DATEADD() in Oracle
  17. Anonymous TABLE or VARRAY type in Oracle
  18. How do I convert a “legacy” left outer join statement in Oracle?
  19. How to Alter Constraint
  20. Array in IN() clause oracle PLSQL
  21. Group by with CLOB in select-statement
  22. How to extract group from regular expression in Oracle?
  23. How to return multiple rows from the stored procedure? (Oracle PL/SQL)
  24. How to extract week number in sql
  25. How to use Timestamp_to_scn and Scn_to_timestamp in Oracle?
  26. In Oracle, is it possible to INSERT or UPDATE a record through a view?
  27. How to handle optional parameters in SQL query?
  28. ORA-01861: literal does not match format string
  29. Backup SQL Schema Only?
  30. IN vs OR of Oracle, which faster?

Leave a Comment