Home
Search results “Sql percentiles oracle”
PERCENTILE_CONT, PERCENTILE_DISC in SQL Server
 
10:52
Click here to Subscribe to IT PORT Channel : https://www.youtube.com/channel/UCMjmoppveJ3mwspLKXYbVlg PERCENTILE_CONT - Calculates a percentile based on a continuous distribution of the column value in SQL Server. The result is interpolated and might not be equal to any of the specific values in the column PERCENTILE_DISC - Computes a specific percentile for sorted values in an entire rowset or within distinct partitions of a rowset in SQL Server. It calculates the percentile based on a discrete distribution of the column values; the result is equal to a specific value in the column. These two analytic functions explained in this Video.
Views: 1729 IT Port
SAP HANA Academy - SQL Functions: PERCENTILE_CONT and PERCENTILE_DISC  [SPS 10]
 
08:01
*** Important: please read this for prerequisites and links to code. In this lesson we'll use the discrete percentile and the continuous percentile functions in SAP HANA. These two functions are Window Functions meaning that they group a query into sets of rows which are named Window Partitions. They differ in their functionality as one value is based on a continuous distribution of column values while the other is based on a discrete distribution, as their names suggest. The code used in this lesson is available here: https://github.com/saphanaacademy/SQL/blob/master/PERCENTILE_CONT_and_PERCENTILE_DISC.SQL * Please see this playlist for more HANA SQL Function videos: https://www.youtube.com/playlist?list=PLkzo92owKnVwpfj5r9EZrPJdZJdUizexs
Views: 3717 SAP HANA Academy
NTILE function in SQL Server
 
05:10
In this video we will discuss NTILE function in SQL Server NTILE function 1. Introduced in SQL Server 2005 2. ORDER BY Clause is required 3. PARTITION BY clause is optional 4. Distributes the rows into a specified number of groups 5. If the number of rows is not divisible by number of groups, you may have groups of two different sizes. 6. Larger groups come before smaller groups For example NTILE(2) of 10 rows divides the rows in 2 Groups (5 in each group) NTILE(3) of 10 rows divides the rows in 3 Groups (4 in first group, 3 in 2nd & 3rd group) Syntax : NTILE (Number_of_Groups) OVER (ORDER BY Col1, Col2, ...) SQL Script to create Employees table Create Table Employees ( Id int primary key, Name nvarchar(50), Gender nvarchar(10), Salary int ) Go Insert Into Employees Values (1, 'Mark', 'Male', 5000) Insert Into Employees Values (2, 'John', 'Male', 4500) Insert Into Employees Values (3, 'Pam', 'Female', 5500) Insert Into Employees Values (4, 'Sara', 'Female', 4000) Insert Into Employees Values (5, 'Todd', 'Male', 3500) Insert Into Employees Values (6, 'Mary', 'Female', 5000) Insert Into Employees Values (7, 'Ben', 'Male', 6500) Insert Into Employees Values (8, 'Jodi', 'Female', 7000) Insert Into Employees Values (9, 'Tom', 'Male', 5500) Insert Into Employees Values (10, 'Ron', 'Male', 5000) Go NTILE function without PARTITION BY clause : Divides the 10 rows into 3 groups. 4 rows in first group, 3 rows in the 2nd & 3rd group. SELECT Name, Gender, Salary, NTILE(3) OVER (ORDER BY Salary) AS [Ntile] FROM Employees What if the specified number of groups is GREATER THAN the number of rows NTILE function will try to create as many groups as possible with one row in each group. With 10 rows in the table, NTILE(11) will create 10 groups with 1 row in each group. SELECT Name, Gender, Salary, NTILE(11) OVER (ORDER BY Salary) AS [Ntile] FROM Employees NTILE function with PARTITION BY clause : When the data is partitioned, NTILE function creates the specified number of groups with in each partition. The following query partitions the data into 2 partitions (Male & Female). NTILE(3) creates 3 groups in each of the partitions. SELECT Name, Gender, Salary, NTILE(3) OVER (PARTITION BY GENDER ORDER BY Salary) AS [Ntile] FROM Employees Link for all dot net and sql server video tutorial playlists https://www.youtube.com/user/kudvenkat/playlists?sort=dd&view=1 Link for slides, code samples and text version of the video http://csharp-video-tutorials.blogspot.com/2015/10/ntile-function-in-sql-server.html
Views: 37688 kudvenkat
Let's Learn SQL! Lesson 70 : What is the Percent_Rank Over Statement?
 
03:17
Explore SQL with Tom Coffing of Coffing Data Warehousing! In this lesson, learn about the Percent_Rank Over statement in Rank!
TSQL: How To Get the Percentile
 
02:53
ETL Course: https://www.udemy.com/automatingetl/
Views: 213 SQLInSix Minutes
PERCENTILE_CONT, PERCENTILE_DISC in SQL Server Tamil
 
12:15
Click here to Subscribe to IT PORT Channel : https://www.youtube.com/channel/UCMjmoppveJ3mwspLKXYbVlg PERCENTILE_CONT - Calculates a percentile based on a continuous distribution of the column value in SQL Server. The result is interpolated and might not be equal to any of the specific values in the column PERCENTILE_DISC - Computes a specific percentile for sorted values in an entire rowset or within distinct partitions of a rowset in SQL Server. It calculates the percentile based on a discrete distribution of the column values; the result is equal to a specific value in the column. These two analytic functions explained in this Video - Tamil
Views: 557 IT Port
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: 17558 Tech Coach
06 Oracle Stream Analytics - Standard Deviation Pattern
 
03:22
Standard Deviation Use this pattern to calculate the median and then subsequently publish the associated standard deviation values for events, over a streaming time period . ================================= For more information, see http://www.oracle.com/goto/oll Copyright © 2016 Oracle and/or its affiliates. Oracle is a registered trademark of Oracle and/or its affiliates. All rights reserved. Other names may be registered trademarks of their respective owners. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the “Materials”). The Materials are provided “as is” without any warranty of any kind, either express or implied, including without limitation warranties or merchantability, fitness for a particular purpose, and non-infringement.
NTILE() Analytical Function in Oracle Database
 
08:28
NTILE Function in Oracle
Views: 34 Adam Tech
T-SQL: ROW_NUMBER(), RANK(), DENSE_RANK() & NTILE()
 
07:39
T-SQL: ROW_NUMBER(), RANK(), DENSE_RANK() & NTILE() Please check my blog azizsharif.blogspot.com for more videos!
SQL Query Training   70 461 TOP Ranking and Analytic functions
 
01:26:16
Additional Training: http://amzn.to/1RjjJCf Other Trainings: www.AaronBuma.com/free-sql-server-training/ We cover features around the TOP(N) in your query, followed by using the RANK(), DENSE_RANK and ROW_NUMBER. Then on to Analytic Functions to help with your statistical analysis of data. Similar to aggregate functions, analytics functions compute over a group of rows with multiple results within each group. Learn how to properly use each of these analytics functions in combination with enhancements to the OVER clause. Learn the value of CUME_DIST and PERCENT_RANK in your analysis, use LAST_VALUE and FIRST_VALUE along with PERCENTILE_DISC, PERCENTILE_CONT, LEAD and LAG you can look at data in the next and previous row. For previous presentations and notifications of upcoming events, checkout my blog: www.AaronBuma.com or follow @AaronDBuma Slides and scripts are also available at: www.AaronBuma.com
Views: 9450 Aaron Buma
FIRST_VALUE and LAST_VALUE Analytic Functions in Oracle Database
 
14:51
FIRST_VALUE and LAST_VALUE in Oracle Database Oracle FIRST Function Oracle last Function
Views: 59 Adam Tech
SQL: Analytical Functions
 
09:19
In this tutorial, you'll learn how to use the analytical functions..
Views: 36486 radhikaravikumar
part 10 modify partition add list values
 
01:30
alter table modify partition,add list values, list partition, data warehousing
SQL in Oracle 11g Tutorial #11: Aggregate Function(MAX,MIN,SUM,AVG,STDDEV,VARIANCE) in SQL
 
03:31
SQL in Oracle 11g Tutorial #11: Aggregate Function(MAX,MIN,SUM,AVG,STDDEV,VARIANCE) in SQL. Thanks for Watching my Channel “Learn TechToTech”. Please subscribe my channel for getting first updates after uploading video.Social Media pages of Channel are: 1. My Website : www.learnfromrakesh.com 2. My Twitter: https://twitter.com/LearnTechtotech 3. Facebook Page: https://www.facebook.com/LearnTechToTech 4. Blogger : https://learntechtotech.blogspot.in/ 5. Google+ : https://learntechtotech.blogspot.in/ 6. Pinterest : https://in.pinterest.com/LearnTechToTech/ 7. LinkedIn: https://www.linkedin.com/in/Learntechtotech/ Playlist of Different Technology: 1. Operating System : https://goo.gl/q6SfrW 2. Python Programming Language : https://goo.gl/L8b5dc 3. C Language : https://goo.gl/SwvDu9 4. C language for Placement: https://goo.gl/AaQBa4 5. Java: https://goo.gl/M8F2uy 6. MySql : https://goo.gl/vdJbHQ 7. Android Mobile Application Development: https://goo.gl/M6woaT 8. Kotlin Programming Language : https://goo.gl/GXE5cd 9. Go Programming: https://goo.gl/Ua3xYW 10. Internet of Things(IoT): https://goo.gl/f2afkY 11. Oracle 11g : https://goo.gl/zds8r2 12. C++ : https://goo.gl/C1psMT
Views: 68 Learn TechToTech
TSQL: Get Mean, Median and Mode
 
14:11
How to get mean, median and mode in SQL Server.
Views: 3159 SQLInSix Minutes
Creating Calculated Items Using Oracle BI EE
 
02:26
This video teaches you how to create a calculated item for a specific set of data values. A calculated item is a computation between members. To find out more about Oracle BI EE, see the documentation at https://docs.oracle.com/en/middleware Copyright © 2015 Oracle and/or its affiliates. Oracle is a registered trademark of Oracle and/or its affiliates. All rights reserved. Other names may be registered trademarks of their respective owners. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the “Materials”). The Materials are provided “as is” without any warranty of any kind, either express or implied, including without limitation warranties or merchantability, fitness for a particular purpose, and non-infringement.
Oracle : Ntile function
 
01:42
Ntile function's detailed explaination... Oracle tutorials... easy to learn for the biginners.
Views: 279 CONNECT TO LEARN
SQL Aggregates: What are aggregate functions?
 
03:20
Discover aggregate functions in general and what the specific numbers are.
Views: 83 James Marks
SQL Basics Part-5, How to write Case Statements in SQL Server
 
10:32
An easy way to learn SQL in SQL Server Management Studio Environment
Views: 3120 SQL Learn & Share
Moment of Motivation - Watch and Learn
 
02:59
Tom Coffing of Coffing Data Warehouse want you to take a break before moving on to Set Operators. Realize you are an amazing person with talent and ambition. Watch the video, get motivated, and then great ready to learn all about Set Operators!
SQL Tutorial - Window Functions - Ranking with Group By
 
07:14
Another fantastic SQL Tutorial brought to you by BeardedDev. If you are new to working with Windows Functions check out this video: https://youtu.be/H6OTMoXjNiM If you want to find out more about the Group By clause and working with aggregate functions check out this video: https://youtu.be/TYD6gWP3jBg If you are interested in finding out more about ranking functions available in SQL Server check out this video: https://youtu.be/xL7BtCT7ix4 In this tutorial we explore ranking functions as part of Window Functions using the Group By clause within SQL Server. In this example we go through how to rank customers based on the sum of the orders they have placed with us. The window function example also covers the difference between using Rank and Dense_Rank. SQL SELECT Sales_Cust_Id , SUM(Sales_Total) AS Total FROM dbo.Sales_2 GROUP BY Sales_Cust_Id ORDER BY Total DESC SELECT Sales_Cust_Id , SUM(Sales_Total) AS Total , RANK() OVER(ORDER BY SUM(Sales_Total) DESC) AS rnk , DENSE_RANK() OVER(ORDER BY SUM(Sales_Total) DESC) AS dnse FROM dbo.Sales_2 GROUP BY Sales_Cust_Id ORDER BY rnk
Views: 1072 BeardedDev
Percentile function
 
02:42
Recorded with http://screencast-o-matic.com
Views: 116 Diane Bittle
Oracle corr, covar_pop, covar_samp, cum_dist, cum_sum
 
46:37
PL-SQL PART 2. ANALYTIC FUNCTIONS - CORR, COVAR_POP, COVAR_SAMP, CUM_DIST, CUM_SUM
Views: 244 Jide James
How To Create a Cloud Scale Read/Write Cache
 
01:15:20
Learn how to create a read/write cache that scales to Cloud levels. Learn how a SQL based cache can outperfom and replace NoSQL caches. Learn how simple SQL queries can achieve a latency of 1 ms at the 99th percentile. Learn how this cache can be deployed with tools like Maven. Use your favorite language [Java, Python, Go, Ruby, C/C++] and SQL with Oracle Velocity Scale. Oracle TimesTen Cloud Product Manager I now live in the Cloud, but I used to integrate with MVS, AS/400, Tuxedo, CORBA, SOAP, sockets and REST. I started using RDBMS with DEC Rdb/VMS and progressed to Oracle 5, 6, 7, 8i, 9i, 10g, 11g and 12c. I fell in love with Oracle TimesTen In-Memory Database as it is a really fast, simple and highly available RDBMS. I have worked as a consultant, developer and product manager at Oracle over the years. My technical interests are making things go fast [OCI, ODBC and PLSQL] and getting things to work together. I am a fan of Golang and I am looking for a good PowerPoint LLVM compiler ... I am now focused on Oracle TimesTen Velocity Scale. Velocity Scale is a shared nothing, scale out, In-Memory RDBMS based on TimesTen. https://developer.oracle.com/ https://cloud.oracle.com/en_US/tryit
Views: 149 Oracle Developers
Compensation | Creating Compensation Models
 
02:44
This video tutorial applies to Rel 11 through Rel 13. It shows you how to setup and use compensation models.
SQL Server Query Training - Using NTILE
 
09:18
SQL Server Query Training - Using NTILE. Part of the 70-461 exam preparation.
Views: 829 Steve Stedman
SQL - Percentage Formula Calculation H2 Database
 
03:12
Get Source Code/Read : http://intactabode.com/ For Developing support email your Details at : [email protected] Install Free Trail GST Ready Accounting Package Send your Contact information Name, Email, Contact Number to email : [email protected] watch demo in English : https://www.youtube.com/watch?v=a4sFNtZuYzs&ab_channel=IntactAbode watch demo in Hindi : https://www.youtube.com/watch?v=I3eCieDpG3o&ab_channel=IntactAbode Website : http://relybill.com/ To display percent to total in SQL, we want to leverage the ideas we used for rank/running total plus subquery. Different from what we saw in the SQL Subquery section, here we want to use the subquery as part of the SELECT. Let's use an example to illustrate. Say we have the following table, Same Concept int SQL, MySql, H2, HQSLB For Source Code Visit : http://corneey.com/wJ6X2K Subscribe to YouTube channel http://corneey.com/wJ6VoC Like us on Facebook http://corneey.com/wJ6C2l Follow us on Twitter http://corneey.com/wJ6C7x Follow me on Google+ http://corneey.com/wJ6Vhc linkedin http://corneey.com/wJ6V5g
Views: 1043 Intact Abode
Range Unbounded Preceding, Following in SQL Server
 
08:27
Click here to Subscribe to IT PORT Channel : https://www.youtube.com/channel/UCMjmoppveJ3mwspLKXYbVlg From SQL Server 2012, This feature enabled to OVER BY Windowing Functions RANGE refers to those same rows plus any others that have the same matching values RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW – Aggregates all the Value less than Current ROW with Current Range RANGE BETWEEN CURRENT ROW AND UNBOUNDED FOLLOWING – Aggregates all the Value greater than Current Row with Current Range
Views: 186 IT Port
KISS series on Analytics: 02 Options for ranking
 
04:44
Welcome to the KISS video series. Solving problems that typically required complicated SQL in the past, that can now be easily solved with Analytic SQL syntax. In this session, we look at additional ranking functions The sample problem we'll solve is: How do handle ties when ranking values with analytics using DENSE_RANK and ROW_NUMBER Scripts here: https://livesql.oracle.com/apex/livesql/s/clebs8f5n4kr2b3vjvnvvgxkn Watch the entire Analytics playlist at https://www.youtube.com/playlist?list=PLJMaoEWvHwFJDyhMLCkNSSUQWw9waFkIj ========================================­­============== Copyright © 2015 Oracle and/or its affiliates. Oracle is a registered trademark of Oracle and/or its affiliates. All rights reserved. Other names may be registered trademarks of their respective owners. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the “Materials”). The Materials are provided “as is” without any warranty of any kind, either express or implied, including without limitation warranties or merchantability, fitness for a particular purpose, and non-infringement.
Views: 2421 Connor McDonald
Advanced unix date format specifiers
 
05:11
Oracle SQL PLSQL and Unix Shell Scripting
Views: 284 Sridhar Raghavan
TSQL: How To Get the Quartile
 
02:21
ETL Course: https://www.udemy.com/automatingetl/
Views: 77 SQLInSix Minutes
Rank, Percentrank, Percentile
 
06:50
Discover the Rank, Percentrank, and Percentile functions. Select the HD quality option for the best full-screen viewing experience. Visit www.spreadsheetsolving.com for more videos and tutorials!
Views: 353 Spreadsheet Solving
حزم إحصائية (2) ||  Percentile
 
06:17
شرح مادة حزم إحصائية من سمارت تيم بشرح المبدعة رهف الخليلي للإطلاع على كل شيء يخص المادة أو طرح أي استفسار يمكنكم متابعة سمارت تيم عن طريق الروابط التالية :: بيج سمارت تيم ::: https://www.facebook.com/Smarteam016 جروب سمارت تيم :::: www.facebook.com/groups/862560740513577 سمارت تيم على الانستغرام :: www.instagram.com/smartteam016 تطبيق سمارت تيم ::: https://play.google.com/store/apps/details?id=com.smartteam
Views: 686 Smart Team
SQL Query Training - 70-461 TOP(), Ranking, and Analytic functions
 
01:26:16
We will start off with all the features around the TOP(N) in your query, followed by using the RANK(), DENSE_RANK and ROW_NUMBER. Then on to Analytic Functions to help with your statistical analysis of data. Similar to aggregate functions, analytics functions compute over a group of rows with multiple results within each group. Learn how to properly use each of these analytics functions in combination with enhancements to the OVER clause. Learn the value of CUME_DIST and PERCENT_RANK in your analysis, use LAST_VALUE and FIRST_VALUE along with PERCENTILE_DISC, PERCENTILE_CONT, LEAD and LAG you can look at data in the next and previous rows.
Views: 3759 Steve Stedman
Part 16 - Databases - Functions in SQL Server
 
10:04
- Scalar Value Function - Inline Table Valued Function - Multi Statement Table Valued Function
Views: 243 Learn In Urdu
What Is Median?  Why Use Median?
 
11:09
ETL Course: https://www.udemy.com/automatingetl/
Views: 352 SQLInSix Minutes
SQL Q & A Part 4 - Rank Functions - ROW NUMBER(), RANK(), DENSE RANK(), NTILE()
 
03:31
SQL Rank functions return a ranking value for each row in a partition. Depending on the function that is used, some rows might receive the same value as other rows. Explained Rank Functions ROW NUMBER, RANK, DENSE RANK, NTILE in detail with examples SQL Interview Q & A Playlist: https://www.youtube.com/watch?v=t2qoqI5TjSk&list=PLSo-SnVTqbBLavDdG89zpQZDWkoEc9LP_ LINUX Interview Q & A Playlist: https://www.youtube.com/watch?v=1WEZqImoxzs&list=PLSo-SnVTqbBIBjEhxwRV3hbYmfXOWiYmR Technology You Must Know Playlist: https://www.youtube.com/watch?v=9FPrr1f2yjo&list=PLSo-SnVTqbBK4qk42HRrawr17mBITQmJd
Views: 607 Shivanand V
KISS series on Analytics: 04 More ranking options
 
04:20
Welcome to the KISS video series. Solving problems that typically required complicated SQL in the past, that can now be easily solved with Analytic SQL syntax. In this session, we look at more esoteric ranking functions with a more statistical background The sample problem we'll solve is: Show me distributions of Hollywood movie box office sales using PERCENT_RANK, CUME_DIST and NTILE (quartile, decile, tertile, etc) Scripts: https://livesql.oracle.com/apex/livesql/s/clq6jmj1jzju4k23v3tnbzo8u Watch the entire Analytics playlist at https://www.youtube.com/playlist?list=PLJMaoEWvHwFJDyhMLCkNSSUQWw9waFkIj ========================================­­============== Copyright © 2015 Oracle and/or its affiliates. Oracle is a registered trademark of Oracle and/or its affiliates. All rights reserved. Other names may be registered trademarks of their respective owners. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the “Materials”). The Materials are provided “as is” without any warranty of any kind, either express or implied, including without limitation warranties or merchantability, fitness for a particular purpose, and non-infringement.
Views: 1693 Connor McDonald
"Why We Built Our Own Distributed Column Store" by Sam Stokes
 
42:41
How do you understand the behaviour of complex distributed systems in production? Distributed systems can fail in unpredictable, hard-to-detect ways. To track down problems quickly, you need to look for patterns and correlations in your data, trying different ways of breaking it down. "Does the problem occur on just one host, or one partition, or for particular customers?" Sub-second complex queries over large data volumes in real time: sounds like a tall order. The Scuba paper from Facebook describes an architecture that can do it: a low-latency, distributed, schemaless database. Scuba achieves fast queries by storing all data in memory. It stores the raw events, and fans out queries to multiple nodes, so it can support complex queries including aggregates (like mean and percentile statistics) and breakdowns by fields of arbitrary cardinality. Building Honeycomb, we needed a database with these properties, but we had additional constraints: multi-tenancy, cost to serve, and the limited resources of a startup. This talk describes Retriever, a custom-built database inspired by Scuba. Retriever ingests events from Kafka, and chooses disk over memory, using an efficient column-oriented storage model. I'll discuss interesting aspects of the implementation, and lessons learned from operating a hand-rolled database at production scale with paying customers. Sam Stokes HONEYCOMB Sam Stokes is a software engineer who can't leave well enough alone. He's compelled to fix broken things, whether they are software systems, engineering processes or cultures. After watching too many systems catch fire, he's building better smoke detectors at Honeycomb; in a past life he cofounded Rapportive and built recommendation systems at LinkedIn.
Views: 5153 Strange Loop
What Is Oracle Integration Cloud?
 
03:00
Use Oracle Integration Cloud to automate processes, integrate applications and data, build custom web and mobile applications, analyze metrics, and monitor real-time data streams. All in one place. ================================= To improve the video quality, click the gear icon and set the Quality to 1080p/720p HD. For more information, see http://www.oracle.com/goto/oll and http://docs.oracle.com. Copyright © 2017 Oracle and/or its affiliates. Oracle is a registered trademark of Oracle and/or its affiliates. All rights reserved. Other names may be registered trademarks of their respective owners. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the “Materials”). The Materials are provided “as is” without any warranty of any kind, either express or implied, including without limitation warranties or merchantability, fitness for a particular purpose, and non-infringement.
The roadmap for SQL Server - BRK2416
 
01:20:31
SQL Server 2017 has brought to market a new modern data platform including support for Linux, Docker Containers and rich features in intelligent performance, HADR, machine learning, and graph database. Come learn about the roadmap and new functionality planned for SQL Server including intelligent query processing, data virtualization, new features for mission critical security and HADR, and new scenarios for Linux and Docker Containers.
Views: 584 Microsoft Ignite
สอน SQL: การใช้งานฟังก์ชัน FIRST_VALUE(), LAST_VALUE() with Window Function
 
10:41
การหาค่าแรกและค่าสุดท้าย Download a sample (Yummi2012) database file from http://goo.gl/p5JlUQ Download SQL script from http://goo.gl/9Th8XH เชิญสมัครเป็นสมาชิกของช่องนี้ได้ที่ ► https://www.youtube.com/subscription_center?add_user=prasertcbs playlist สอน Microsoft SQL Server 2012, 2014, 2016, 2017 ► https://www.youtube.com/playlist?list=PLoTScYm9O0GH8gYuxpp-jqu5Blc7KbQVn สอน PostgreSQL ► https://www.youtube.com/playlist?list=PLoTScYm9O0GGi_NqmIu43B-PsxA0wtnyH สอน MySQL ► https://www.youtube.com/playlist?list=PLoTScYm9O0GFmJDsZipFCrY6L-0RrBYLT playlist สอน SQLite ► https://www.youtube.com/playlist?list=PLoTScYm9O0GHjYJA4pfG38M5BcrWKf5s2 playlist การใช้ Excel ในการทำงานร่วมกับกับฐานข้อมูล (SQL Server, MySQL, Access) ► https://www.youtube.com/playlist?list=PLoTScYm9O0GGA2sSqNRSXlw0OYuCfDwYk playlist การเชื่อมต่อกับฐานข้อมูล (SQL Server, MySQL, SQLite) ด้วย Python ► https://www.youtube.com/playlist?list=PLoTScYm9O0GEdZtHwU3t9k3dBAlxYoq59 #prasertcbs_SQL #prasertcbs
Views: 2072 prasertcbs
S 13:Find Max salary Dept wise from the source using Aggregator transformation - By Berry.
 
07:42
Scenario 13: Find a maximum salary dept wise from the source file using Aggregator transformation. Aggregator Transformation Aggregator transformation is an Active and Connected transformation. This transformation is useful to perform calculations such as averages and sums (mainly to perform calculations on multiple rows or groups). For example, to calculate total of daily sales or to calculate average of monthly or yearly sales. Aggregate functions such as AVG, FIRST, COUNT, PERCENTILE, MAX, SUM etc. can be used in aggregate transformation.
Views: 1774 Bhaskar Berry
pl-sql tutorial in hindi lec 1 (introduction of pl-sql in hindi)
 
24:16
http://www.bitsinfotec.in/ What is pl-sql. where to use pl-sql, why to use pl-sql. How to use pl-sq, introduction to pl-sql, pl-sql tutorial in hindi by alok sir, pl-sql lectures, pl-sql training, pl-sql for beginners, pl-sql in hindi, pl-sql in oracle tutorial in hindi, pl-sql
Views: 7649 JavaTreePoint
MS Excel - Table unpivot by Power Query Excel 2016
 
01:07
Адрес страницы в Facebook - https://www.fb.com/excel.lessons Дорогие друзья, приглашаем Вас на онлайн-курсы Продвинутого Excel. Резюме тренера программы представлено в заметках страницы. Обучение ведется с помощью программы Skype - в режиме демонстрации экрана.
Using the Mean, Median and Mode Funcitons
 
02:13
Using the Mean, Median and Mode functions in Excel
Views: 601 titantechtraining

Meperitab 50mg generic viagra
Difference between generic and brand name synthroid side
Allegra d mg
Governador valadares mg habitantes
Fluoxetine 40 mg withdrawal ease