SQL Query to get all Records from a versioned geodatabase

[BhargavaRam]

Does anybody know the query to get the latest of ALL records in a versioned SDE geodatabase (including records from the add and delete (A&D) tables? I'm specifically looking for SQL Server.

[Asrujit_SenGupta]

Instead of querying the Feature Classes or Tables, try to pull the updated data from the Versioned views. Versioned view will show data from the Base\Business Tables and the Delta Tables both, which is what you need.

[BhargavaRam]

Thanks Gupta for quick response.

Versioned views holds the data only after the versions are  "reconcile & post" to default.

Is there any query/method to get the all the records before i post it to default?  

[Asrujit_SenGupta]

Read versioned data in SQL Server using versioned views—Help | ArcGIS for Desktop 

This link should give you the idea.