SQL Video Tutorials
- SELECT query with LIMIT and order by with WHERE condition checking using BETWEEN range
18-Sep-2020
- Getting unique data from columns of MySQL table by using DISTINCT query
23-Jul-2020
- SQL BETWEEN to get rows within a range with all other commands
15-Aug-2020
- SQL LIKE query to use wildcards to partially match strings with combination of AND OR NOT
21-Aug-2020
- Order by MySQL query to display rows based on order of columns
23-Aug-2020
- Sum of values of columns in MySQL table with GROUP BY , IN and CASE
06-Sep-2020
- MySQL query to get Average value of a column by using avg() along with GROUP BY , in and Having
07-Sep-2020
- CROSS JOIN of tables to link with all rows and use of WHERE query
09-Sep-2020
- Joining tables Using SQL LEFT Join, RIGHT Join and Inner Join
13-Sep-2020
- SQL MAX for Highest record of the column with all other details
18-May-2020
- Creating Yearly,monthly,year–month, part of month and quarter reports using group by in date column
29-Sep-2020
- Grouping financial data based on Financial year Quarters by using the date column
29-Sep-2020
- Joining strings by using CONCAT and handling NULL value.
30-Sep-2020
- Records of different date ranges by using DATE_SUB(), CURDATE() and BETWEEN() query.
30-Sep-2020
- CURDATE() to get todays, yesterday and tomorrow date with first day last of previous , next months
30-Sep-2020
- NOW() to get todays, yesterday and tomorrow date with time with sample queries
03-Oct-2020
- DAYNAME() function to get full name of the weekday in MySQL
03-Oct-2020
- MONTHNAME() function to get full name of the month in MySQL
03-Oct-2020
- DAYOFWEEK() function to get number from 1 to 7 based on Weekday in MySQL
03-Oct-2020
- WEEKDAY() function to get number from 0 to 6 based on Weekday in MySQL
03-Oct-2020
What is SQL Query with WHERE Condition Collecting data by linking more than one table
Subhendu Mohapatra
Author
🎥 Join me live on YouTubePassionate about coding and teaching, I publish practical tutorials on PHP, Python, JavaScript, SQL, and web development. My goal is to make learning simple, engaging, and project‑oriented with real examples and source code.
Subscribe to our YouTube Channel here
This article is written by plus2net.com team.
https://www.plus2net.com
SQL Video Tutorials