SQL #16 - SQL Group By Having in SQL in Tamil | SQL Tutorials in Tamil

#MSSQL# #Tutorials# #Joins# This tutorial will help you to learn MS SQL from the beginning to Advanced level in Tamil. This is one of the best youtube channel to learn SQL step by step in tamil. Points are covered in this video:- Group BY Used to group rows that have the same values in specified columns. Often used with aggregate functions like SUM(), COUNT(), AVG(), MIN(), MAX(). How to group data by department to see the total count How to group data by department to see the total salary Having Used to filter grouped records (after GROUP BY). Works with aggregate functions (SUM(), COUNT(), AVG(), etc.). Similar to WHERE, but WHERE cannot be used with aggregates. Retrieve Data from multiple tables based on an equality The common column is mandatory The common column datatype must be same Matching Data/Rows The purpose of different sub-Languages? What is DDL? What is DMS? What is DRL? What is TCL? What is DCL? How to create new database in SQL? How to create new table in SQL? How to create table in difference interface? Points are covered in previous video:- How to connect to server by using Windows Authentication & New Database in Tamil? Different types of way to connect to SQL Server? How to work with SQL? How to connect to SSMS? What is SSMS? Different Server Types? Server Name & Authentication What is SQL in Tamil? What is database? How to create database in SQL? What's UI interface? What is GUI interface in Tamil? What is CUI interface in Tamil? Why MsSQL is important? What are SQL commands? 1. How to Install MS SQL Server & SSMS Installation Guide - https://youtu.be/Fwk2hCUqGKU 2. Introduction & Overview of SQL in Tamil - https://youtu.be/yOuX-LT9z7Q 3. MSSQL Server & SSMS SQL in Tamil | How to work with SQL?- https://youtu.be/IRjo5lEURag 4. Windows Authentication & New Database in Tamil - https://youtu.be/XtE-671EGvM 5. Different Data Type in Tamil https://youtu.be/PDJFXJfv_1g 6. SQL Sub-Languages & Create Table in SQL in Tamil https://youtu.be/jAXitrkZgWA 7. SQL Sub-Languages DDL, ALTER, DROP, TRUNCATE in SQL in Tamil | SQL Tutorials in Tamil - https://youtu.be/lmpbvBXtXbY 8. SQL Sub-Languages DML, INSERT, UPDATE & DELETE in SQL in Tamil - https://youtu.be/wapwRw2tjVM 9. Sub-Languages DML or DRL, SELECT, WHERE Commands - https://youtu.be/qh9JC-FRLDk 10. IDENTITY Function in DML or DRL, Sub-Languages in SQL in Tamil - https://youtu.be/fjeGrUBB7UM 11. Primary Key & Foreign Key Function in SQL in Tamil | SQL Tutorials in Tamil - https://youtu.be/n-bjGP7pNSY MS Excel Videos - https://youtube.com/playlist?list=PL5tWfOTy8mUnnh-GqZro06C8VHHoOMo8u Power BI Tutorials - https://youtube.com/playlist?list=PL5tWfOTy8mUlH6eclgLEf8fvoi16qURWX VBA Macros Step by Step Video - https://youtube.com/playlist?list=PL5tWfOTy8mUmzW14STtKwm6rjwUMG_Km6 Source File - https://meet.google.com/ain-vxwk-uqu Shorts - https://youtube.com/playlist?list=PL5tWfOTy8mUkkrNgBvBRlFqruv6dXyqEX Excel Interview Questions and Answers - https://youtube.com/playlist?list=PL5tWfOTy8mUn-_znlSCnriZOKE45txyDT We are happy to assist with your queries and file. Please book the next available 30-minute slot with Santhu Analytics for further support. https://meetpro.club/SanthuAnalytics App link - https://khal.page.link/ew2y Ms Excel, Ms Word, VBA, Power Point, Power BI Email ID - [email protected] Please subscribe, like, commend and share it with your friends.