Practical SQL Guide : The SELECT Dilemma (Part 1)
Recap... It is Diwali 2024 today and I have nothing more to do rather than writing a blog down. Hoping that Diwali went good for you, let's re-begin the journey. And we will be going with the SELECT statement. There are lot of things about tables That I need to cover, but those can actually be explained when we have some idea of SELECT statement. Afterall you will use SELECT statement the most. So without further ado, let's begin. The Vanilla SELECT Vanilla is purest of flavors, nothing else. In software industry you will hear vanilla this vanilla that , often times, referring to the un-adulterated piece of software. In the similar manner, Vanilla SELECT refers to the very commonly unadulterated code of SELECT statement used in SQL. You have used it many times now, through this series. And that is, if you haven't guessed it yet, is : SELECT * FROM < table_name > It is the mostly used statement in SQL to be honest, and it doesn't contain any specification(flavor...
