SQL Query to Get Latest Record
There are times when we require to find latest record in siebel through SQL.
Following are the SQL which fetches the latest records of S_SRV_REQ table.
SELECT * FROM SIEBEL.S_SRV_REQ
WHERE CREATED = (SELECT MAX(CREATED) FROM SIEBEL.S_SRV_REQ);
OR
SELECT * FROM SIEBEL.S_SRV_REQ
WHERE (CREATED>sysdate);
Note : CREATED Column is the created date of the record.
No comments:
Post a Comment