Menu
I currently have a SQLTIPS.sql file, which lives on my hard disk, at work.
I'll add any new or nice examples, of writing good SQL, to this file. Now it's becoming hard to manage, and I have to search for specifics, in my own file!
I am looking for something that can be loaded in SQL Enterprise Manager quickly, something similar to Visual Studio IDE code snippets.
989
So try to memorise the following consecutive statements: SELECT→FROM→WHERE. Next, remember that the SELECT statement refers to the column names, the FROM keyword refers to the table/database used, and the WHERE clause refers to specific conditions that are investigated by the user.
An SQL SELECT statement retrieves records from a database table according to clauses (for example, FROM and WHERE ) that specify criteria. The syntax is: SELECT column1, column2 FROM table1, table2 WHERE column2='value';
SQL is used in everyday life by some of the biggest companies like Netflix, Linkedin, Amazon, Flipkart, Instagram. Uber for data analysis and performance analysis. Even small companies and startups employ SQL for similar purposes. SQL is a great tool for interacting with databases and fetching vital data.
I have each example snippet stored in a separate .sql file, give it some meaningful name, and preferably some comments at top.
I use Dropbox to have it available on all machines I am using, and Google Desktop to search for what i need (the proper comments come handy then)
151
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
