I have a table that I select data from using sql, and I try to select the most current record from that table for the primary key, MYCOL1. In the case of the data shown below from my table, I need to select both rows, because MYCOL8 is distinct,. What can I add to my select statement so that I can select both rows below, not just Row1, which is what my current query is yielding. Thank you!
SELECT * FROM MYTABLE A
AND MYCOL10 = (SELECT MAX(MYCOL10)
FROM MYTABLE B
WHERE A.MYCOL1 = B.MYCOL1
AND A.MYCOL2 = B.MYCOL2);
Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.
Why doesn't the Oracle optimizer use my index?
Querying too much data
Most Oracle developers know that an index is useful when you can use it to restrict your result set to a small number of the total rows in a table.
So, the obvious side…
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface. I made a script to download the Alert Log, look for errors, and email me the trace files. In this article I'll describe what I did and share my script.