SQL selecting rows by most recent date with two unique columns

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

Related Posts:

  1. ORA-00904: invalid identifier
  2. how to fix oracle ORA-01722 invalid number error
  3. ORA-00979 not a group by expression
  4. ORA-00907: missing right parenthesis
  5. How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?
  6. ORA-01843 not a valid month- Comparing Dates
  7. ORA-00918: column ambiguously defined in SELECT *
  8. Oracle error : ORA-00905: Missing keyword
  9. How do I limit the number of rows returned by an Oracle query after ordering?
  10. Oracle SELECT TOP 10 records
  11. Can a foreign key be NULL and/or duplicate?
  12. How to Select Top 100 rows in Oracle?
  13. ORA-12560: TNS:protocol adaptor error
  14. ORA-00972 identifier is too long alias column name
  15. Oracle Apex column link from LOV values
  16. PLS-00103: Encountered the symbol when expecting one of the following:
  17. What’s the difference between RANK() and DENSE_RANK() functions in oracle?
  18. ORA-00918: column ambiguously defined in SELECT *
  19. ORA-00918: column ambiguously defined in SELECT *
  20. Oracle – ORA-01489: result of string concatenation is too long [duplicate]
  21. ORA-01861: literal does not match format string
  22. What is it exactly a BLOB in a DBMS context
  23. “ORA-01438: value larger than specified precision allowed for this column” when inserting 3
  24. How do you create a temporary table in an Oracle database?
  25. Oracle “Partition By” Keyword
  26. How to insert date values into table
  27. Oracle SQL: Update a table with data from another table
  28. ORA-06502: PL/SQL: numeric or value error: character string buffer too small
  29. Comparing Dates in Oracle SQL
  30. Convert timestamp to date in Oracle SQL
  31. How do I reset a sequence in Oracle?
  32. Update statement with inner join on Oracle
  33. MySQL equivalent of DECODE function in Oracle
  34. Oracle: If Table Exists
  35. DATEDIFF function in Oracle
  36. How to create id with AUTO_INCREMENT on Oracle?
  37. LEFT function in Oracle
  38. What is the difference between Views and Materialized Views in Oracle?
  39. How do I view the Explain Plan in Oracle Sql developer?
  40. ORA-01779: cannot modify a column which maps to a non key-preserved table
  41. ORA-01735: invalid ALTER TABLE option – Toad
  42. ora-06553 pls-306 wrong number or types of arguments in call to ‘ogc_x’
  43. What’s the best way to search for a UPC code in a Database?
  44. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  45. What is the difference between “INNER JOIN” and “OUTER JOIN”?
  46. What is the difference between “INNER JOIN” and “OUTER JOIN”?
  47. What is the difference between UNION and UNION ALL?
  48. Selecting COUNT(*) with DISTINCT
  49. Case in Select Statement
  50. What is a stored procedure?
  51. SQL WITH clause example [duplicate]
  52. Unknown column in ‘field list’ error on MySQL Update query
  53. Unknown column in ‘field list’ error on MySQL Update query
  54. SQL Inner-join with 3 tables?
  55. The wait operation timed out. ASP
  56. What is SELF JOIN and when would you use it? [duplicate]
  57. The wait operation timed out. ASP
  58. Conversion failed when converting date and/or time from character string while inserting datetime
  59. Self Join to get employee manager name
  60. How do I UPDATE from a SELECT in SQL Server?
  61. SQL error “ORA-01722: invalid number”
  62. SQL query to select dates between two dates
  63. MySQL – Operand should contain 1 column(s)
  64. SQL SELECT WHERE field contains words
  65. Conversion failed when converting date and/or time from character string while inserting datetime
  66. When should I use CROSS APPLY over INNER JOIN?
  67. MySQL “CREATE TABLE IF NOT EXISTS” -> Error 1050
  68. Insert Data Into Temp Table with Query
  69. QL Error: ORA-00933: SQL command not properly ended
  70. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  71. MySQL create table if not exists and insert record only if table was created
  72. error, string or binary data would be truncated when trying to insert
  73. How to create Temp table with SELECT * INTO tempTable FROM CTE Query
  74. NOT IN vs NOT EXISTS
  75. SQL SELECT WHERE field contains words
  76. Online SQL Query Syntax Checker
  77. How can I do an UPDATE statement with JOIN in SQL Server?
  78. Must declare the scalar variable
  79. How do I use properly CASE..WHEN in MySQL
  80. Must declare the scalar variable
  81. Rename column SQL Server 2008
  82. Why do we need “Relationships” between tables at all?
  83. INSERT statement conflicted with the FOREIGN KEY constraint – SQL Server
  84. Using group by on multiple columns
  85. Efficiently convert rows to columns in sql server
  86. How can I do a FULL OUTER JOIN in MySQL?
  87. Nested select statement in SQL Server
  88. INSERT statement conflicted with the FOREIGN KEY constraint – SQL Server
  89. Using group by on multiple columns
  90. SQL SELECT WHERE field contains words
  91. MySQL query String contains
  92. How do I escape a single quote in SQL Server?
  93. What’s the difference between VARCHAR and CHAR?
  94. Case statement in MySQL
  95. T-SQL split string based on delimiter
  96. How to declare a variable in MySQL?
  97. Finding duplicate values in a SQL table
  98. MySQL Cannot Add Foreign Key Constraint
  99. Drop a temporary table if it exists
  100. How do I escape a single quote in SQL Server?

Leave a Comment

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)