Lukas Eder shows how much variety there is in a simple request:
Do you need to know what RDBMS Server version you’re on, and you only have SQL at your disposal? No problem. Most RDBMS provide you with that information in some form of meta data table.
Read on to see just how different each each platform is.