FLOOR() Function: SQL FLOOR is used to return the largest integer less than or equal to the specified numeric expression. Syntax: EXAMPLE: The result is the numeric part with the same data type. CEILING() Function: SQL CIELING() is used to get the smallest integer greater than, or equal to, the specified numeric expression as return …
SQL date functions are important to learn if you want to do anything related to-Forecasting.Managing historical data.There are several types of SQL Date functions but we are going to learn basics first. The Three SQL functions we are going to learn in this lesson are – DATEPART() This function returns an integer representing the specified datepart of …
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 CTE? SQL CTE or common table expressions are temporary tables created by the result of some other query. They have their name and can be referenced in SQL statements.They are created using WITH clause encapsulating SQL statements. Syntax Of CTE: EXAMPLE: For Example we are going to use the EMPLOYEE table. For …
SQL Common Table Expression(CTE) -CLEAR And PRECISE Read More »
SQL views are virtual tables created by the user. SQL views can also be considered as a subset of tables.SQL views provide security features to users as they can be used to keep the main table safe or inaccessible to others. Syntax of Views: Updating View: Dropping View: EXAMPLE: We will use the following table …
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 …
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 …
