Most of the standard SQL commands work with SDE, so this should be pretty similar to the examples that you have seen. Note that there are certain keywords (I don't have a list) that do not work in SDE because they are proprietary to a certain RDBMS.
Thanks,
Tope