Is the Data registered as Versioned?
If yes, then from the Database end, query the Versioned View created for that data. That should show the desired results.
*****
When a Feature Class(FC) is Registered as Versioned, two extra tables, known as Delta Tables (a- & d- Tables) are created on the Database end. This is in addition to the Base Table (Table with same name as the FC) already created when the FC was created in ArcCatalog.
Edits made to these Versioned FC will move to the Delta Tables and remain there, till you perform the Compress operation(and Reconcile\Post of other versions when applicable).
The Versioned View is created for that FC, when it was Registered as Versioned. This View shows data from all 3 Tables (Base Table, a- Table & d- Table).
*****