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 »
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 …
SQL functions are used to perform mathematical, statistical, and logical operations. CONCAT() The CONCAT() function helps in adding two or more strings. EXAMPLE: Here is the demo table that we will use:Demo table name is DOCTORS. Here we will concatenate ‘speciality’ column with ‘hospital’ column. You can also use ‘+’ sign to concatenate CONCAT_WS This …
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 »
SQL IN SQL IN helps you specify multiple values in a WHERE clause. EXAMPLE: For example we will use the following table:- Suppose you want to find only the rows where Subject is either ‘English’ or ‘Maths’ , here’s how you can do it. You can also combine IN keyword with NOT in the WHERE …
SQL having clause is used where you have to use some kind of aggregate as a condition. SYNTAX: EXAMPLE This is a demo table. Now suppose you have to find the subjects with average marks more than 80, here is how you will do it. Here is what happens when you use WHERE clause instead …
SQL is the most important computer language if you want to get hired in any type of company nowadays. Without SQL it is impossible to work with big data. If your Job has any relation to data. I think it is very important to master SQL and basic database fundamentals. Here are some important questions …
