Home
Search results “Oracle rownum in group”
Oracle Partition By clause, Oracle Analytic Functions tutorial
 
09:09
More about analytic functions, visit https://www.youtube.com/watch?v=Ukekis8C-SI&list=PL99-DcFspRUoscBHdh39T8EHENfm2VcQ3&index=2 Oracle Analytic Functions and Over By Partition clause enable calculating cumulative and moving aggregates returning multiple rows for each group.
HOW TO IDENTIFY AND DELETE DUPLICATE ROWS USING ROWID AND GROUPBY IN ORACLE SQL
 
07:53
This video demonstrates examples on how to find and delete duplicate records from a table. The video gives simple and easy to understand examples on finding duplicate records from a table using group by and having clause and row_number function. It also shows the ways in which duplicates can be deleted very efficiently using the rowid of that record. You can get the code from our website http://oracleplsqlblog.com/FullBlog/FullBlog/21
Views: 12535 Kishan Mashru
SQL Partition By Explained
 
06:42
Using Oracle's SQL, I'll explain how to use Partition By. This will be similar in other SQL engines that have the Partition By keyword.
Views: 36978 Pretty Printed
SQL: Group By,  Having, Min, Max Sum
 
14:43
Learn to summarize yoru data using the SQL Aggregates such as count and sum and the GROUP BY and HAVING clauses of the SELECT statement
Views: 161507 Michael Fudge
4 of 6  SQL Advanced with Oracle  - Inline subquery and rownum
 
04:53
This video gives an example of an inline subquery, a query in the FROM clause of another query. We also see how we might use the rownum option to limit how many rows of output we get. (4 of 6) There is also an "SQL Fundamentals" series. (Search for "databasemec" for tutorials using SQL Server.)
Views: 10899 Jennifer Kreie
Select Rows With Max Value By Group SQL Interview Question
 
10:06
How to select the max value from each set using group by in the free Adventure Works database. This example is done using sql server using SQL Server Management Studio. This is a common interview question. How to install SQL Server Management Studio and set up Adventure Works: https://www.youtube.com/watch?v=b6yNwGC7CY4&t=
Views: 1710 Blake B
Oracle SQL PLSQL 12C Tutorial 21 - Group By, Having Clause
 
02:52
This Video Tutorial Will Describe about using GROUP BY and HAVING CLAUSE to group the data of rows based on conditions. These command will also work on other versions of database like Oracle 11g Database, Oracle 10g Database, Oracle 9i Database, Oracle 8i Database, Oracle 8 Database and so on. In this video i explain how to use GROUP BY CLAUSE to group the column value of multiple rows. And HAVING Clause to use conditions to group only certain rows. Full Syntax will be given in this video tutorial about how to use these constraints. Along with live example of using GROUP BY and HAVING Clause. All the keywords, format, mandatory clauses etc are described in this video. The background music comes from Ross Bugden - Music channel. Link mentioned below: https://www.youtube.com/channel/UCQKGLOK2FqmVgVwYferltKQ and music link is : https://www.youtube.com/watch?v=BY0U432m8W0
Views: 9 game hounds
SQL Server interview question :- Explain RowNumber,Partition,Rank and DenseRank ?
 
10:50
For more such videos visit http://www.questpond.com See our other Step by Step video series below :- Learn SQL Server Step by Step in 16 hours:- http://tinyurl.com/ja4zmwu Learn Angular tutorial for beginners https://tinyurl.com/ycd9j895 Learn MVC Core step by step :- http://tinyurl.com/y9jt3wkv Learn MVC 5 Step by Step in 16 hours:- https://goo.gl/dmdakg Learn MSBI Step by Step in 32 hours:- https://goo.gl/TTpFZN Learn Xamarin Mobile Programming Step by Step :- https://goo.gl/WDVFuy Learn Design Pattern Step by Step in 8 hours:- https://goo.gl/eJdn0m Learn C# Step by Step in 100 hours :- https://goo.gl/FNlqn3 Learn Data structures & algorithm in 8 hours :-https://tinyurl.com/ybx29c5s Learn Javascript in 2 hours :- http://tinyurl.com/zkljbdl Learn SharePoint Step by Step in 8 hours:- https://goo.gl/XQKHeP Learn TypeScript in 45 Minutes :- https://goo.gl/oRkawI Learn webpack in 50 minutes:- https://goo.gl/ab7VJi Learn Visual Studio code in 10 steps for beginners:- https://tinyurl.com/lwgv8r8 Learn Tableau step by step :- https://tinyurl.com/kh6ojyo SQL Server interview question :- Explain RowNumber,Partition,Rank and DenseRank ? We are also distributing a 100 page Ebook "Sql Server Interview Questions". If you want this ebook please share this video in your facebook/twitter/linkedin account and email us on [email protected] with the shared link and we will email you the PDF.
how to use "ROWNUM" in oracle
 
09:05
this video shows how we can display a range of records in ORACLE DATABASE using SQL
Views: 1844 P-Square Technologies
How to Fetch Latest record/row from the Table in Oracle Database
 
03:32
You will learn how to How to Fetch Latest record/row from the Table in Oracle Database. Realtime Scenario: This logic can be implemented to find whether the latest record should be inserted or updated to datawarehouse
GROUP BY, ROLLUP and CUBE in Oracle
 
04:09
Here's a quick run through of GROUP BY, ROLLUP and CUBE, along with an example of using the GROUPING function. For more information see: https://oracle-base.com/articles/misc/rollup-cube-grouping-functions-and-grouping-sets Website: https://oracle-base.com Blog: https://oracle-base.com/blog Twitter: https://twitter.com/oraclebase Cameo by Kerry Osborne Blog: http://kerryosborne.oracle-guy.com/ Twitter: https://twitter.com/KerryOracleGuy Cameo appearances are for fun, not an endorsement of the content of this video.
Views: 18928 ORACLE-BASE.com
How to find nth Max salary in a table
 
12:10
This video is useful to find the nth max salary from a table. It shows all the different ways and possibilities to find the nth max salary from a table, using a rownum sub query and the later on using a dense rank function.
Views: 14528 Kishan Mashru
GROUP BY with Aggregate functions in SQL statement
 
25:01
Using "GROUP BY" clause with Aggregate functions in SQL statement Check the whole "SQL Server Basics" series here: https://www.youtube.com/playlist?list=PLU9JMEzjCv14f3cWDhubPaddxRvx1reKR Check my SQL blog at: http://sqlwithmanoj.com/ Check my SQL FB Page at: https://www.facebook.com/sqlwithmanoj
Views: 48517 SQL with Manoj
ORACLE DATABASE - CREATE VIEW, SYNONYM, ROWNUM, SEQUENCE.
 
43:16
Dibuat untuk memenuhi tugas mata kuliah Sistem Basis Data
Views: 47 Ari Abd
Oracle Tutorial - Date Functions NEXT_DAY | LAST_DAY
 
07:13
Oracle Tutorials - Date Functions NEXT_DAY( ) | LAST_DAY( )
Views: 300 Tech Acad
Oracle DENSE_RANK Function
 
04:09
https://www.databasestar.com/oracle-dense_rank/ The Oracle DENSE_RANK function allows you to calculate a rank of a row in a group of rows. It returns this rank as a NUMBER value. This function can be used as either an analytic or an aggregate function, and the syntax depends on how you use it. As an aggregate function it looks like this: DENSE_RANK ( expr, [expr(n)] ) WITHIN GROUP ( ORDER BY (order_expr [ASC|DESC] [NULLS FIRST|LAST] ) These parameters are: - expr: this is the value to search for in a particular table. You can specify multiple search values, and just separate them by a comma. - order_expr: this is used to order the expr values by, because you get a different results depending on what order you rank the values in. - NULLS FIRST or LAST: this is where you can specify if you want to have NULL values appear at the top of your ranking order or at the bottom. As an analytic function, it looks like this: DENSE_RANK() OVER ( [query_partition_clause] order_by_clause) The parameters are: - query_partition_clause: this is the expression that the ranking is “grouped” by, as analytic functions allow you to group data within rows. - order_by_clause: this is the expression to order your results by to determine a rank. For this function, if two records have the same sort or rank position, they will have the same RANK value. It won’t cause a gap in the rankings, unlike the RANK function which does cause a gap. For more information about the Oracle DENSE_RANK function, including all of the SQL shown in this video and the examples, read the related article here: https://www.databasestar.com/oracle-dense_rank/
Views: 560 Database Star
Oracle Partition By clause, Oracle Analytic Functions tutorial
 
09:09
Oracle Analytic Functions and Over By Partition clause enable calculating cumulative and moving aggregates returning multiple rows for each group
SQL: pseudo columns (Rowid/Rownum)
 
05:54
In this tutorial, u'll learn the difference between rowid & rownum..
Views: 32645 radhikaravikumar
Group By, Group sets, Rollup, Cube
 
10:38
Demonstrating the user of Group by Clause, grouping sets, Rollup and Cube Clause with simple examples
Views: 14782 Naveen Kumar
HAVING clause and difference with GROUP BY & WHERE clause in SQL statement
 
10:17
Using HAVING clause and difference with GROUP BY & WHERE clause in SQL statement Link for scripts on my blog: https://sqlwithmanoj.com/2015/05/23/sql-basics-difference-between-where-group-by-and-having-clause/ Check the whole "SQL Server Basics" series here: https://www.youtube.com/playlist?list=PLU9JMEzjCv14f3cWDhubPaddxRvx1reKR Check my SQL blog at: http://sqlwithmanoj.com/ Check my SQL FB Page at: https://www.facebook.com/sqlwithmanoj
Views: 77850 SQL with Manoj
Difference Between Case and Decode
 
06:03
What is the difference between case and decode ? Important links for Oracle Developers For for SQL - PL/SQL Interview Questions Answers Facebook group https://www.facebook.com/groups/146487615764170/ Download Free PLSQL Interview Books , Documents Videos from here https://www.facebook.com/groups/146487615764170/files/ Free SQL / PLSQL Video on YouTube Channel SUBSCRIBE https://www.youtube.com/c/ramguptaoracle?sub_confirmation=1 Visit oracle forms / report / SQL PLSQL blog http://oracletemple.blogspot.in/ Oracle Community Google+ https://plus.google.com/u/0/collection/4mW-jB Join our facebook group https://www.facebook.com/groups/146487615764170/ Follow us on Twitter https://twitter.com/Rameshwar275 Simply Like and Share :) Oracle SQL PLSQL FaceBook group https://www.facebook.com/groups/146487615764170/ ORACLE SQL PLSQL VIDEO LINKS What is Parameterized Cursor in Oracle https://www.youtube.com/watch?v=JMKwHlVi6-A What is autonomous transaction in Oracle. https://www.youtube.com/watch?v=gyvFajpfoWE What are Constraints available in Oracle. https://www.youtube.com/watch?v=WivhdLXQklQ What is Mutation Error and How to avoid mutation. https://www.youtube.com/watch?v=CbWNCyW18Bs 5 Effective way to delete Duplicate rows https://www.youtube.com/watch?v=1wtTtnc87Oc What is Difference between Delete and Truncate https://www.youtube.com/watch?v=7b6wQ3Qumgg What are types of View available in Oracle https://www.youtube.com/edit?o=U&video_id=PN-NsSA2R-E
Views: 4409 Ram Gupta
Oracle - SQL - Advanced Grouping
 
07:03
Oracle - SQL - Advanced Grouping Watch more Videos at https://www.tutorialspoint.com/videotutorials/index.htm Lecture By: Mr. Anadi Sharma, Tutorials Point India Private Limited.
SQL Tutorial - 26: The GROUP BY Clause
 
08:18
In this tutorial we'll check out the GROUP BY Clause. The GROUP BY Clause is used to get together identical data obtained in result sets. We will also briefly talk about two aggregate functions in SQL.
Views: 84139 The Bad Tutorials
Oracle Part 9 Group By and Having
 
23:15
Group by, Having, Delete, Truncate, Rowid
Views: 975 Free OpenMentor
SQL: Group By & Having Clause
 
05:59
In this tutorial, you'll learn how to use group by and having clause...
Views: 30730 radhikaravikumar
ROLLUP & CUBE in SQL | Oracle SQL Tutorial Videos | Mr.Vijay Kumar
 
17:23
ROLLUP & CUBE in SQL | Oracle SQL Tutorial Videos | Mr.Vijay Kumar ** For Online Training Registration: https://goo.gl/r6kJbB ► Call: +91-8179191999 💡 Visit Our Website for Classroom Training: https://nareshit.in/oracle-training/ 💡 For Online Training: https://nareshit.com/oracle-online-training/ #OracleOnlineTraining #OracleCourse #oracleCoaching #OracleTraining -------------------------- 💡 About NareshIT: "Naresh IT is having 14+ years of experience in software training industry and the best Software Training Institute for online training, classroom training, weekend training, corporate training of Hadoop, Salesforce, AWS, DevOps, Spark, Data Science, Python, Tableau, RPA , Java, C#.NET, ASP.NET, Oracle, Testing Tools, Silver light, Linq, SQL Server, Selenium, Android, iPhone, C Language, C++, PHP and Digital Marketing in USA, Hyderabad, Chennai and Vijayawada, Bangalore India which provides online training across all the locations -------------------------- 💡 Our Online Training Features: 🎈 Training with Real-Time Experts 🎈 Industry Specific Scenario’s 🎈 Flexible Timings 🎈 Soft Copy of Material 🎈 Share Videos of each and every session. -------------------------- 💡 Please write back to us at 📧 [email protected]/ 📧 [email protected] or Call us at the USA: ☎+1404-232-9879 or India: ☎ +918179191999 -------------------------- 💡 Check The Below Links ► For Course Reg: https://goo.gl/r6kJbB ► Subscribe to Our Channel: https://goo.gl/q9ozyG ► Circle us on G+: https://plus.google.com/+NareshIT ► Like us on Facebook: https://www.facebook.com/NareshIT ► Follow us on Twitter: https://twitter.com/nareshitek ► Follow us on Linkedin: https://goo.gl/CRBZ5F ► Follow us on Instagram: https://goo.gl/3UXYK3 Category Education Category Education
Views: 22890 Naresh i Technologies
Leaner, Faster Code with Advanced SQL Techniques
 
45:45
Connor Mcdonald, Developer Advocate for SQL, Oracle Most SQL is so simple to write that we can hand off the job to an ORM tool or a similar mechanism. But by delving a little deeper into more-advanced SQL facilities, we can get performance benefits and write a lot less middle-tier code. This session highlights some SQL techniques for solving problems that would otherwise require a lot of complex coding. Learn how to become a more productive developer by expanding your knowledge of the SQL language.
Views: 9369 Oracle Developers
SQL TOP, RANK, DENSE_RANK, ROW_NUMBER Functions
 
08:27
Jamie King of Neumont University demonstrating various SQL ranking functions.
Views: 24391 Jamie King
Oracle SQL PLSQL 12C Tutorial 21 - Group By, Having Clause
 
02:52
This Video Tutorial Will Describe about using GROUP BY and HAVING CLAUSE to group the data of rows based on conditions. These command will also work on other versions of database like Oracle 11g Database, Oracle 10g Database, Oracle 9i Database, Oracle 8i Database, Oracle 8 Database and so on. In this video i explain how to use GROUP BY CLAUSE to group the column value of multiple rows. And HAVING Clause to use conditions to group only certain rows. Full Syntax will be given in this video tutorial about how to use these constraints. Along with live example of using GROUP BY and HAVING Clause. All the keywords, format, mandatory clauses etc are described in this video. Gymnopedie No 3 by Kevin MacLeod is licensed under a Creative Commons Attribution license (https://creativecommons.org/licenses/by/4.0/) Source: http://incompetech.com/music/royalty-free/index.html?isrc=USUAN1100785 Artist: http://incompetech.com/
ROWNUM vs ROWID in Oracle Explain with Examples
 
04:55
Oracle ROWNUM and ROWID
Views: 120 Adam Tech
SQL query to find first record and last record in single query
 
08:55
SQL query to find first record and last record in single query
Views: 12107 SQL Guru
WHERE vs HAVING Clause | Oracle SQL Tutorial Videos | Mr.Vijay Kumar
 
11:20
WHERE vs HAVING Clause | Oracle SQL Tutorial Videos | Mr.Vijay Kumar ** For Online Training Registration: https://goo.gl/r6kJbB ► Call: +91-8179191999 💡 Visit Our Website for Classroom Training: https://nareshit.in/oracle-training/ 💡 For Online Training: https://nareshit.com/oracle-online-training/ #OracleOnlineTraining #OracleCourse #oracleCoaching #OracleTraining -------------------------- 💡 About NareshIT: "Naresh IT is having 14+ years of experience in software training industry and the best Software Training Institute for online training, classroom training, weekend training, corporate training of Hadoop, Salesforce, AWS, DevOps, Spark, Data Science, Python, Tableau, RPA , Java, C#.NET, ASP.NET, Oracle, Testing Tools, Silver light, Linq, SQL Server, Selenium, Android, iPhone, C Language, C++, PHP and Digital Marketing in USA, Hyderabad, Chennai and Vijayawada, Bangalore India which provides online training across all the locations -------------------------- 💡 Our Online Training Features: 🎈 Training with Real-Time Experts 🎈 Industry Specific Scenario’s 🎈 Flexible Timings 🎈 Soft Copy of Material 🎈 Share Videos of each and every session. -------------------------- 💡 Please write back to us at 📧 [email protected]/ 📧 [email protected] or Call us at the USA: ☎+1404-232-9879 or India: ☎ +918179191999 -------------------------- 💡 Check The Below Links ► For Course Reg: https://goo.gl/r6kJbB ► Subscribe to Our Channel: https://goo.gl/q9ozyG ► Circle us on G+: https://plus.google.com/+NareshIT ► Like us on Facebook: https://www.facebook.com/NareshIT ► Follow us on Twitter: https://twitter.com/nareshitek ► Follow us on Linkedin: https://goo.gl/CRBZ5F ► Follow us on Instagram: https://goo.gl/3UXYK3 Category Education Category Education
Views: 17315 Naresh i Technologies
Rank and Dense Rank in SQL Server
 
10:08
rank and dense_rank example difference between rank and dense_rank with example rank vs dense_rank in sql server 2008 sql server difference between rank and dense_rank In this video we will discuss Rank and Dense_Rank functions in SQL Server Rank and Dense_Rank functions Introduced in SQL Server 2005 Returns a rank starting at 1 based on the ordering of rows imposed by the ORDER BY clause ORDER BY clause is required PARTITION BY clause is optional When the data is partitioned, rank is reset to 1 when the partition changes Difference between Rank and Dense_Rank functions Rank function skips ranking(s) if there is a tie where as Dense_Rank will not. For example : If you have 2 rows at rank 1 and you have 5 rows in total. RANK() returns - 1, 1, 3, 4, 5 DENSE_RANK returns - 1, 1, 2, 3, 4 Syntax : RANK() OVER (ORDER BY Col1, Col2, ...) DENSE_RANK() OVER (ORDER BY Col1, Col2, ...) RANK() and DENSE_RANK() functions without PARTITION BY clause : In this example, data is not partitioned, so RANK() function provides a consecutive numbering except when there is a tie. Rank 2 is skipped as there are 2 rows at rank 1. The third row gets rank 3. DENSE_RANK() on the other hand will not skip ranks if there is a tie. The first 2 rows get rank 1. Third row gets rank 2. SELECT Name, Salary, Gender, RANK() OVER (ORDER BY Salary DESC) AS [Rank], DENSE_RANK() OVER (ORDER BY Salary DESC) AS DenseRank FROM Employees RANK() and DENSE_RANK() functions with PARTITION BY clause : Notice when the partition changes from Female to Male Rank is reset to 1 SELECT Name, Salary, Gender, RANK() OVER (PARTITION BY Gender ORDER BY Salary DESC) AS [Rank], DENSE_RANK() OVER (PARTITION BY Gender ORDER BY Salary DESC) AS DenseRank FROM Employees Use case for RANK and DENSE_RANK functions : Both these functions can be used to find Nth highest salary. However, which function to use depends on what you want to do when there is a tie. Let me explain with an example. If there are 2 employees with the FIRST highest salary, there are 2 different business cases 1. If your business case is, not to produce any result for the SECOND highest salary, then use RANK function 2. If your business case is to return the next Salary after the tied rows as the SECOND highest Salary, then use DENSE_RANK function Since we have 2 Employees with the FIRST highest salary. Rank() function will not return any rows for the SECOND highest Salary. WITH Result AS ( SELECT Salary, RANK() OVER (ORDER BY Salary DESC) AS Salary_Rank FROM Employees ) SELECT TOP 1 Salary FROM Result WHERE Salary_Rank = 2 Though we have 2 Employees with the FIRST highest salary. Dense_Rank() function returns, the next Salary after the tied rows as the SECOND highest Salary WITH Result AS ( SELECT Salary, DENSE_RANK() OVER (ORDER BY Salary DESC) AS Salary_Rank FROM Employees ) SELECT TOP 1 Salary FROM Result WHERE Salary_Rank = 2 You can also use RANK and DENSE_RANK functions to find the Nth highest Salary among Male or Female employee groups. The following query finds the 3rd highest salary amount paid among the Female employees group WITH Result AS ( SELECT Salary, Gender, DENSE_RANK() OVER (PARTITION BY Gender ORDER BY Salary DESC) AS Salary_Rank FROM Employees ) SELECT TOP 1 Salary FROM Result WHERE Salary_Rank = 3 AND Gender = 'Female' Text version of the video http://csharp-video-tutorials.blogspot.com/2015/10/rank-and-denserank-in-sql-server.html Slides http://csharp-video-tutorials.blogspot.com/2015/10/rank-and-denserank-in-sql-server_1.html All SQL Server Text Articles http://csharp-video-tutorials.blogspot.com/p/free-sql-server-video-tutorials-for.html All SQL Server Slides http://csharp-video-tutorials.blogspot.com/p/sql-server.html All Dot Net and SQL Server Tutorials in English https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd All Dot Net and SQL Server Tutorials in Arabic https://www.youtube.com/c/KudvenkatArabic/playlists
Views: 86619 kudvenkat
Oracle rollup and cube - Rollup and cube in Oracle with examples - Group by function in SQL
 
14:36
Rollup and cube are group by function in SQL. Use of Rollup and cube are explained in this video in Oracle with examples. These functions are very important as they allow to generate certain reports which required subtotals and grand totals to be calculated using group by clause in SQL #BasicSQL #LearnSQL #Crazy4DB #MunshiSir #Oracle #GroupByClause SQL DECODE and CASE : https://youtu.be/-TK-7oI59DE Group Functions Examples : https://youtu.be/fx4EnMdyTOM A complete course on SQL : https://www.youtube.com/playlist?list=PLdNnjIwbbBta7tveno_un-C7VVFY-F24Z My web site : http://www.oracletrainingnagpur.com My blog : https://crazy4db.blogspot.in My facebook page : https://www.facebook.com/crazy4db/
Views: 116 Crazy4 DB
T-SQL: Over() and Partition By
 
04:17
Show how to use OVER and PARTITION BY to get groups of data with aggregation.
Views: 10965 MidnightDBA
How to find nth Highest Salary in SQL ( 6 Methods )
 
13:57
This video describes how to find out nth highest salary, different / various methods / ways/types to find nth highest/lowest salary/income value using SQL server.Simple ways to get/extract particular amount.It give brief explanation with live/real time/practical examples.This is one of the most interview question in SQL. How to retrieve nth position of record of from table? , SQL Server interview question and answers.Query to select top max salary from given table.
Views: 33555 Tech Jago
SQL Tutorial : How To Delete Duplicate Records in SQL Oracle
 
07:43
SQL Tutorial : How To Delete Duplicate Records in SQL Oracle SQL Tutorial SQL Tutorial for beginners PLSQL Tutorial PLSQL Tutorial for beginners PL/SQL Tutorial PL SQL Tutorial PL SQL Tutorial for beginners PL/SQL Tutorial for beginners Oracle SQL Tutorial
Views: 5042 TechLake
Grouping Sets in SQL Server
 
09:36
grouping sets examples in sql server sql server grouping sets order by grouping sql server 2008 grouping sets example sql server group by union all Grouping sets is a new feature introduced in SQL Server 2008. Let us understand Grouping sets with an example. We want to calculate Sum of Salary by Country and Gender. We can very easily achieve this using a Group By query as shown below Select Country, Gender, Sum(Salary) as TotalSalary From Employees Group By Country, Gender Within the same result set we also want Sum of Salary just by Country. To achieve the above result we could combine 2 Group By queries using UNION ALL as shown below. Select Country, Gender, Sum(Salary) as TotalSalary From Employees Group By Country, Gender UNION ALL Select Country, NULL, Sum(Salary) as TotalSalary From Employees Group By Country Within the same result set we also want Sum of Salary just by Gender. We can achieve this by combining 3 Group By queries using UNION ALL as shown below Select Country, Gender, Sum(Salary) as TotalSalary From Employees Group By Country, Gender UNION ALL Select Country, NULL, Sum(Salary) as TotalSalary From Employees Group By Country UNION ALL Select NULL, Gender, Sum(Salary) as TotalSalary From Employees Group By Gender Finally we also want the grand total of Salary. In this case we are not grouping on any particular column. So both Country and Gender columns will be NULL in the resultset. To achieve this we will have to combine the fourth query using UNION ALL as shown below. Select Country, Gender, Sum(Salary) as TotalSalary From Employees Group By Country, Gender UNION ALL Select Country, NULL, Sum(Salary) as TotalSalary From Employees Group By Country UNION ALL Select NULL, Gender, Sum(Salary) as TotalSalary From Employees Group By Gender UNION ALL Select NULL, NULL, Sum(Salary) as TotalSalary From Employees There are 2 problems with the above approach. The query is huge as we have combined different Group By queries using UNION ALL operator. This can grow even more if we start to add more groups The Employees table has to be accessed 4 times, once for every query. If we use Grouping Sets feature introduced in SQL Server 2008, the amount of T-SQL code that you have to write will be greatly reduced. The following Grouping Sets query produce the same result as the above UNION ALL query. Select Country, Gender, Sum(Salary) TotalSalary From Employees Group BY GROUPING SETS ( (Country, Gender), -- Sum of Salary by Country and Gender (Country), -- Sum of Salary by Country (Gender) , -- Sum of Salary by Gender () -- Grand Total ) The order of the rows in the result set is not the same as in the case of UNION ALL query. To control the order use order by as shown below. Select Country, Gender, Sum(Salary) TotalSalary From Employees Group BY GROUPING SETS ( (Country, Gender), -- Sum of Salary by Country and Gender (Country), -- Sum of Salary by Country (Gender) , -- Sum of Salary by Gender () -- Grand Total ) Order By Grouping(Country), Grouping(Gender), Gender Text version of the video http://csharp-video-tutorials.blogspot.com/2015/09/grouping-sets-in-sql-server.html Slides http://csharp-video-tutorials.blogspot.com/2015/09/grouping-sets-in-sql-server_19.html All SQL Server Text Articles http://csharp-video-tutorials.blogspot.com/p/free-sql-server-video-tutorials-for.html All SQL Server Slides http://csharp-video-tutorials.blogspot.com/p/sql-server.html All Dot Net and SQL Server Tutorials in English https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd All Dot Net and SQL Server Tutorials in Arabic https://www.youtube.com/c/KudvenkatArabic/playlists
Views: 53434 kudvenkat
Analytical Functions in oracle explained with real examples
 
25:24
This video explains analytical functions and how they are implemented in real projects. Analytical functions are somewhat similar to aggregate functions,but they offer much more. Why use analytical function ? They allow you to write fast and concise queries which otherwise will involve self join and long processing times They allow you to perform aggregate functions independently on sets of partitions. You can access values from previous rows in current row and you can restrict the window on which you want to apply this analytical function. I have given additional practice exercises along with the dataset so that you can comfortably work with analytical functions. You can find the sample problems along with dataset in the below link. http://www.internshipsfromhome.com/oracle-analytical-functions-ddl-and-dml/
Views: 29540 Tech Coach
Advanced SQL Queries in Oracle and SQL Server - What is ROLLUP?
 
04:14
This video clip, on the ROLLUP Extension to GROUP BY, is taken from my www.pluralsight.com course "Advanced SQL Queries in Oracle and SQL Server". Click here to learn more about this course: http://www.pluralsight.com/courses/adv-sql-queries-oracle-sql-server?utm_source=youtube&utm_medium=video&utm_campaign=authordemo.
Views: 2386 sheepsqueezersYT
How to use Oracle SQL ROLLUP and CUBE
 
06:12
Learn how the Oracle Database SQL extensions ROLLUP and CUBE provide additional aggregations for your data warehouse data.
Views: 2894 SkillBuilders
Oracle developer 11g Session 3 Very Important Using the ( Decode + Case When + Group Functions )
 
59:07
Support my fan Please https://www.facebook.com/Learnoraclewithward Very Important choose Settings and choose Quality 720p HD To Watch High Quality , Download also High Quality
Views: 4316 Ahmed Ward
SQL Tutorial for Beginners Group By, Having , CUBE and ROLLUP
 
12:33
Oracle SQL Group By, Having , CUBE and ROLLUP Grouping Functions SQL Tutorial SQL Tutorial for beginners Oracle SQL Tutorial for beginners
Views: 6273 TechLake
How to delete duplicate records from a table in oracle
 
02:01
Let c how to remove duplicates from a table..I have one table here 'student' It has two duplicate records. 3 joe 4 robert These two records has duplicates. So I have to remove them. I can remove them using rowid functionality using one subquery. You can give different column names in GROUP BY clause. to identify the duplicate record. You can give just primary key values also. Duplicate rows are deleted now... Query used in video: delete from student where rowid not in (select min(rowid) from student group by sno,sname); Thanks for watching...:)
Views: 15895 WingsOfTechnology
ROWID - DBArch Video 32
 
05:20
In this video you will understand what is ROWID in an Oracle Database, where is it stored and what are its components. Our Upcoming Online Course Schedule is available in the url below https://docs.google.com/spreadsheets/d/1qKpKf32Zn_SSvbeDblv2UCjvtHIS1ad2_VXHh2m08yY/edit#gid=0 Reach us at [email protected]
Views: 4822 Ramkumar Swaminathan
SQL SELECT TOP Clause or LIMIT, OFFSET  and  ROWNUM  Telugu | SQL Telugu Tutorial-vlr training
 
03:59
For all sql videos in Telugu :http://www.vlrtraining.in/sql-training-videos-telugu/ In Telugu: What is the use of ROWNUM in Oracle? What is LIMIT in MySQL? SQL SELECT TOP, LIMIT, ROWNUM SQL TOP, LIMIT or ROWNUM Clause SQL SELECT TOP, LIMIT, ROWNUM SQL Tutorial; SQL SELECT TOP Command Select top in SQL Server SQL SELECT TOP Clause The SELECT TOP clause is used to specify the number of records to return. What is limit in MySQL Limit Data Selections From a MySQL Database. MySQL provides a LIMIT clause that is used to specify the number of records to return. The LIMIT clause makes it easy to code multi page results or pagination with SQL and is very useful for large tables. The SELECT TOP clause is useful on large tables with thousands of records. Returning a large number of records can impact on performance. In English: download sql study material Website: http://www.vlrtrain.in/2016/09/download-sql-files.html Learn SQL sql tutorial for beginners sql commands oracle sql tutorial sql tutorial advanced mysql tutorial sql tutorial video SQL Tutorial, Tutorials SQL
Views: 3520 VLR Training
What the PARTITION BY clause does in Analytic Functions Oracle SQL
 
09:14
In this tutorial video we will learn how to use PARTITION BY clause in Analytic Functions Oracle SQL
Views: 2194 Spod ssppoodd
SQL Tutorial : Differences between Where and Having clauses in oracle
 
05:32
SQL Tutorial : Differences between Where and Having clauses in oracle SQL Tutorial SQL Tutorial for beginners PLSQL Tutorial PLSQL Tutorial for beginners PL/SQL Tutorial PL SQL Tutorial PL SQL Tutorial for beginners PL/SQL Tutorial for beginners Oracle SQL Tutorial
Views: 1324 TechLake