I'm needing to create a query using Oracle SQL that that will display the first two attributes in a table and then the last
2 attributes of a particular table, for example sakes I'll call it the PRODUCT table.
After working on it for a while I know I can use this to get the first 2:
WHERE ROWNUM <=2;
But how would I make it also show the last 2
within the same query?