Many times we get this need to find out the Latest Record written to the database.
Well, here is the simple/basic SQL query which works!!
SELECT * FROM SIEBEL.S_ADDR_ORG
WHERE CREATED = (SELECT MAX(CREATED) FROM SIEBEL.S_ADDR_ORG);
Here CREATED Column is the created date of the record.
Well, here is the simple/basic SQL query which works!!
SELECT * FROM SIEBEL.S_ADDR_ORG
WHERE CREATED = (SELECT MAX(CREATED) FROM SIEBEL.S_ADDR_ORG);
Here CREATED Column is the created date of the record.
No comments:
Post a Comment