When it comes to syntax, SQL is not that tough and quite easy if you compare it with other languages. Some basic syntax rules a SQL newbie should know are as follows:- SQL Commands SELECT & FROM The SELECT command is used to specify which columns you want to retrieve from the table(s). FROM keyword …
SQL Basic (SELECT, FROM, INSERT, UPDATE, DELETE)-Simplified Read More »
Introductiuon In SQL, Creating and inserting data is important but maintaining databases are also important. Sometimes user are not happy with the current name of the table and wants to rename them according to needs. CAUTION : Before committing to any change, user should double check that renaming the table will not make or break …
SQL LIKE SQL LIKE operators are used in conjunction with WHERE clause to find patterns in the strings. Two wild card characters are used with LIKE operators-‘%’ is used to represent zero, one, or multiple character‘_’ is used when you want to represent only one character Syntax: WHERE Clause in above statement will match with …
SQL is now one of the most sought-after skill by many IT companies. As the amount of Data generated by the rapidly increasing population of the earth increases, we need more and more people who are proficient in accessing, handling, and managing data. Here is how you can learn SQL fast and easy. Below is …
What are SQL joins? SQL GROUP BY is used to group rows with similar values for aggregate functions. Without GROUP BY user cannot use aggregate functions. Syntax: Now lets use GROUP BY with HAVING Thanks For Reading! SOURCE : https://learn.microsoft.com/en-us/sql/t-sql/queries/select-group-by-transact-sql?view=sql-server-ver16 READ MORE:SQL BASICSSQL WINDOW FUNCTIONSSQL ORDER BY
What is SQL ORDER BY ? SQL ORDER BY is used to arrange the Query result into ascending and descending order. ORDER BY is also used in important SQL concepts like Windows functions. It works on both numerical and alphabetical values. Syntax of ORDER BY : EXAMPLE : We will use the following table EMPLOYEE …
SQL ORDER BY- HOW AND WHERE TO USE? – SIMPLIFIED Read More »
Stored procedures are sets of SQL code that can be saved to the database and can be called anytime the user wants to execute them. Most of the time stored procedures are SQL queries that are repeated daily so it is a time-saving manoeuvre to store them for future use. Syntax: After creating the stored …
SQL Stored Procedures – Simplified with Examples Read More »
What are joins in SQL ? SQL joins are used to combine two or more tables using column(s) as reference.Nowadays most databases are normalized so it’s important to know the basics of SQL joins. In the above example, we have two tables named demo_tab_1 and demo_tab_2. We used the join clause to join them, ON …
Windows functions are one of the most important concepts of SQL language. They are also known as Analytical functions.SQL window functions exist so that we can bypass the flaws of SQL aggregate functions.The primary flaw of SQL aggregate functions is that they collapse the rows to a single row whenever we use them. Below is …
Data insertion in SQL database is done using the INSERT INTO statements. Syntax: In the insert statement you need to specify the the name of the table, column names, and values you want to insert. Note:You need to follow the order when you specify the column names and values.If you are inserting values into all …
