Home
Search results “Max in pl sql oracle”
SQL:Max/Min Functions
 
03:38
In this tutorial, you'll learn how to use max min functions in sql queries. PL/SQL (Procedural Language/Structured Query Language) is Oracle Corporation's procedural extension for SQL and the Oracle relational database. PL/SQL is available in Oracle Database (since version 7), TimesTen in-memory database (since version 11.2.1), and IBM DB2 (since version 9.7).[1] Oracle Corporation usually extends PL/SQL functionality with each successive release of the Oracle Database. PL/SQL includes procedural language elements such as conditions and loops. It allows declaration of constants and variables, procedures and functions, types and variables of those types, and triggers. It can handle exceptions (runtime errors). Arrays are supported involving the use of PL/SQL collections. Implementations from version 8 of Oracle Database onwards have included features associated with object-orientation. One can create PL/SQL units such as procedures, functions, packages, types, and triggers, which are stored in the database for reuse by applications that use any of the Oracle Database programmatic interfaces. PL/SQL works analogously to the embedded procedural languages associated with other relational databases. For example, Sybase ASE and Microsoft SQL Server have Transact-SQL, PostgreSQL has PL/pgSQL (which emulates PL/SQL to an extent), and IBM DB2 includes SQL Procedural Language,[2] which conforms to the ISO SQL’s SQL/PSM standard. The designers of PL/SQL modeled its syntax on that of Ada. Both Ada and PL/SQL have Pascal as a common ancestor, and so PL/SQL also resembles Pascal in several aspects. However, the structure of a PL/SQL package does not resemble the basic Object Pascal program structure as implemented by a Borland Delphi or Free Pascal unit. Programmers can define public and private global data-types, constants and static variables in a PL/SQL package.[3] PL/SQL also allows for the definition of classes and instantiating these as objects in PL/SQL code. This resembles usage in object-oriented programming languages like Object Pascal, C++ and Java. PL/SQL refers to a class as an "Abstract Data Type" (ADT) or "User Defined Type" (UDT), and defines it as an Oracle SQL data-type as opposed to a PL/SQL user-defined type, allowing its use in both the Oracle SQL Engine and the Oracle PL/SQL engine. The constructor and methods of an Abstract Data Type are written in PL/SQL. The resulting Abstract Data Type can operate as an object class in PL/SQL. Such objects can also persist as column values in Oracle database tables. PL/SQL is fundamentally distinct from Transact-SQL, despite superficial similarities. Porting code from one to the other usually involves non-trivial work, not only due to the differences in the feature sets of the two languages,[4] but also due to the very significant differences in the way Oracle and SQL Server deal with concurrency and locking. There are software tools available that claim to facilitate porting including Oracle Translation Scratch Editor,[5] CEITON MSSQL/Oracle Compiler [6] and SwisSQL.[7] The StepSqlite product is a PL/SQL compiler for the popular small database SQLite. PL/SQL Program Unit A PL/SQL program unit is one of the following: PL/SQL anonymous block, procedure, function, package specification, package body, trigger, type specification, type body, library. Program units are the PL/SQL source code that is compiled, developed and ultimately executed on the database. The basic unit of a PL/SQL source program is the block, which groups together related declarations and statements. A PL/SQL block is defined by the keywords DECLARE, BEGIN, EXCEPTION, and END. These keywords divide the block into a declarative part, an executable part, and an exception-handling part. The declaration section is optional and may be used to define and initialize constants and variables. If a variable is not initialized then it defaults to NULL value. The optional exception-handling part is used to handle run time errors. Only the executable part is required. A block can have a label. Package Packages are groups of conceptually linked functions, procedures, variables, PL/SQL table and record TYPE statements, constants, cursors etc. The use of packages promotes re-use of code. Packages are composed of the package specification and an optional package body. The specification is the interface to the application; it declares the types, variables, constants, exceptions, cursors, and subprograms available. The body fully defines cursors and subprograms, and so implements the specification. Two advantages of packages are: Modular approach, encapsulation/hiding of business logic, security, performance improvement, re-usability. They support object-oriented programming features like function overloading and encapsulation. Using package variables one can declare session level (scoped) variables, since variables declared in the package specification have a session scope.
Views: 4589 radhikaravikumar
Oracle SQL Video Tutorial 28  - MAX and MIN functions
 
07:32
Oracle SQL Video Tutorials 28 - MAX and MIN functions explained.In This Oracle SQL Tutorial for Beginners, I have explained basics of SQL.These examples work on Oracle 10g and Oracle 11g database. These helps youto understand Oracle Joins and helps beginners. Iam going to add more tutorials on Oracle DBA, Oracle RAC and Oracle PL/SQL.All Oracle sql tutorial with examples are executed on Oracle 11g using Oracle SQL Developer.
Views: 3524 Just Channel
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: 153971 Michael Fudge
Fonction SQL ORACLE - MAX et MIN
 
03:18
Fonction SQL ORACLE - MAX et MIN. Une petite présentation des deux fonctions MAX et MIN. Abonnez-vous à la chaîne pour ne pas manquer mes prochaines vidéos. N'hésitez pas à me suivre sur: Site Web: http://www.courssql.com Facebook: https://www.facebook.com/CoursSQL Twitter: https://twitter.com/Cours_SQL Google+: https://plus.google.com/108599494665250923662/posts
Views: 275 Cours SQL
Calculate  Maximum of Two Numbers in Oracle PLSQL
 
07:13
Calculate Maximum of Two Numbers in Oracle Function Calculate Maximum of Two Numbers in PLSQL bigger value in function MAX(x,y
Views: 18 Adam Tech
Oracle SQL, PL/SQL, Select Kullanımı ve Eğitimi 2 - Select, min, max, sum, count, avg, having
 
05:57
Oracle SQL, PL/SQL, Select Kullanımı ve Eğitimi 2 -Select, min, max, sum, count, avg, having, oracle select statement, oracle select education, PL/SQL Select, min, max, sum, count, avg, having, PL/SQL Beğendiyseniz Beğen Butonuna basmayı ve Abone olarak destek olmayı unutmayın.
Views: 237 Taner TOPCU
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: 12814 Kishan Mashru
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: 23063 Tech Coach
SelectTec | Aula Nº 25 | Max e Min - Oracle SQL Developer
 
05:24
min syntax: select min(coluna) from tabela; select max(coluna) from tabela; ou select min(coluna1), max(coluna2) from tabela; select min(coluna1), max(coluna1) from tabela;
Views: 1521 SelectTec
Vídeo Aula 9 - Curso de PL/SQL Oracle
 
21:23
Nesta vídeo aula sao apresentados funções de agregação, no qual sao apresentadas algumas funçoes de agregação como GROUP BY, AVG, MAX, MIN, SUM, COUNT e etc.
Views: 3740 LabDeInformatica
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: 6152 Oracle Developers
PL/SQL tutorial 59: PL/SQL Collection Method COUNT in Oracle Database by Manish Sharma
 
04:53
RebellionRider presents PL/SQL tutorial explaining the concepts of Collection Method COUNT in Oracle Database. This tutorial will help you in learning the basics of COUNT function. This video will also help you in learning – What is collection method Count in Oracle Database • How to use COUNT function • How to use COUNT function with IF Condition • How to use COUNT function with For-Loop Hope you will enjoy. Do make sure to Like, Share & Subscribe. Thanks Tweet Link: https://twitter.com/OracleSQLDev/status/872441483223281664 Follow me on Twitter: https://twitter.com/RebellionRider ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog: http://bit.ly/count-function Previous Tutorial ► Introduction to collection methods https://youtu.be/8V40IaOkGcU ► Tut 51. How to create nested table https://youtu.be/EUYyiFCzU0I ------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the 1st one to see my videos! ------------------------------------------------------------------------- ►►►Find me on Social Media◄◄◄ Follow What I am up to as it happens on https://twitter.com/rebellionrider http://instagram.com/rebellionrider https://plus.google.com/+Rebellionrider http://in.linkedin.com/in/mannbhardwaj/ ___Facebook Official Page of Manish Sharma___ https://www.facebook.com/TheRebellionRider/ ___Facebook Official Page of RebellionRider.com___ https://www.facebook.com/RebellionRider.official/ You can also Email me at for E-mail address please check the About section Please please LIKE and SHARE my videos it makes me happy. Thanks for liking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com ♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS
Views: 8338 Manish Sharma
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
Basic aggregate functions in Oracle plsql.
 
19:22
Understanding basic aggregate functions in pl sql. A simple pl sql tutorial which demonstrate how to use basic aggregate functions like sum, avg, count, max and min.
Views: 355 Subhroneel Ganguly
Collections in PL/SQL | Oracle PL/SQL Tutorial Videos | Mr.Vijay Kumar
 
14:34
Collections in PL/SQL PLSQL Tutorial
Views: 31563 Naresh i Technologies
Using the MAX and MIN functions (Introduction to Oracle SQL)
 
04:23
Learn how to use the MAX and MIN functions. The full Introduction to Oracle SQL course is available here: https://www.databasestar.com/introduction-to-oracle-sql-course/
Views: 121 Database Star
oracle plsql records and collections   introduction to oracle collections
 
16:06
oracle plsql records and collections - Introduction to collections in oracle oracle collections tutorial series - Video -1 , introduction to records and collections
Views: 457 Siva Academy
Tutorial Perintah SELECT ASC, DESC, MIN, MAX dan WHERE menggunakan ORACLE SQL DEVELOPER PART 4
 
14:10
SELECT ASC ORACLE SQL DEVELOPER SELECT DESC ORACLE SQL DEVELOPER SELECCT MIN ORACLE SQL DEVELOPER SELECT MAX ORACLE SQL DEVELOPER SELECT WHERE ORACLE SQL DEVELOPER --------------------------------------------------------------------------------------------------------------------------- CREATE TABLE ARTIS ( KD_ARTIS VARCHAR(4) NOT NULL, NM_ARTIS VARCHAR(30) NOT NULL, JK VARCHAR(6) NOT NULL, BAYARAN NUMBER NOT NULL, AWARD NUMBER(2) NOT NULL, NEGARA VARCHAR(4) NOT NULL, CONSTRAINT ARTIS_PK PRIMARY KEY(KD_ARTIS) ENABLE ); --------------------------------------------------------------------------------------------------------------------------- CREATE TABLE FILM ( KD_FILM VARCHAR(4) NOT NULL, NM_FILM VARCHAR(30) NOT NULL, ARTIS VARCHAR(4) NOT NULL, PENDAPATAN NUMBER NOT NULL, NOMINASI NUMBER(2) NOT NULL, CONSTRAINT FILM_PK PRIMARY KEY (KD_FILM) ENABLE ); --------------------------------------------------------------------------------------------------------------------------- SELECT * FROM FILM; --------------------------------------------------------------------------------------------------------------------------- //1.urutkan nama film dan nominasi dari nominasi yg terbesar SELECT NM_FILM, NOMINASI FROM FILM ORDER BY NOMINASI DESC; --------------------------------------------------------------------------------------------------------------------------- //2.tampilkan nama film dan nominasi yg paling banyak mendapatkan nominasi SELECT NM_FILM, NOMINASI FROM FILM WHERE NOMINASI = ( SELECT MAX(NOMINASI) FROM FILM ); --------------------------------------------------------------------------------------------------------------------------- SELECT MAX(NOMINASI) FROM FILM; --------------------------------------------------------------------------------------------------------------------------- //3.tampilkan nama film dan nominasi yg tidak dapat nominasi SELECT NM_FILM, NOMINASI FROM FILM WHERE NOMINASI = '0'; --------------------------------------------------------------------------------------------------------------------------- //4.tampilkan nama film dan pendapatan dari yg terkecil SELECT NM_FILM, NOMINASI FROM FILM ORDER BY NOMINASI ASC; --------------------------------------------------------------------------------------------------------------------------- //5.tampilkan nama film dan pendapatan yg terbesar SELECT NM_FILM, PENDAPATAN FROM FILM WHERE PENDAPATAN = ( SELECT MAX(PENDAPATAN) FROM FILM ); --------------------------------------------------------------------------------------------------------------------------- //6.tampikan nama film dan pendapatan yg terkecil SELECT NM_FILM, PENDAPATAN FROM FILM WHERE PENDAPATAN = ( SELECT MIN(PENDAPATAN) FROM FILM ); ---------------------------------------------------------------------------------------------------------------------------
Views: 28 Dwiki Olajuwon
Oracle Tutorial - Aggregate Functions AVG | SUM | MIN | MAX | COUNT
 
13:54
Oracle Tutorials - Aggregate Functions avg () Sum () Min () Max () Count ()
Views: 106 Tech Acad
34. Aggregate Functions in PL/SQL Oracle
 
06:50
In this video you will learn about Aggregate Functions in PL/SQL Oracle. For Support =========== Email: [email protected] Contact Form: http://www.learninhindi.com/home/contact Our Social Media ================ Facebook: https://www.facebook.com/LearnInHindi Twitter: https://twitter.com/LearnInHindi For Training & Videos ===================== For more videos and articles visit: http://www.learninhindi.com Free Java Programming In Hindi Course ===================================== https://www.youtube.com/playlist?list=PLOZ3jentlCDAwwhMyoLISrxkXTADGp7PH Free Oracle PL/SQL Programming In Hindi Course ============================================== https://www.youtube.com/playlist?list=PLB5DA82419C2D99B6 Free C Programming In Hindi Course ================================== https://www.youtube.com/playlist?list=PLOZ3jentlCDAxKpBLMWogxSdy6BZcsAJq Trips & Tricks Channel ====================== https://www.youtube.com/channel/UCGmLfkuCo-3lHHJXRJ9HUMw Programming in Hindi Channel ============================ https://www.youtube.com/channel/UCudElIDgwNrybeAvXIy1HZQ
Views: 7331 ITORIAN
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: 10688 Kishan Mashru
Query to Select top three Max Salary from Table
 
03:37
In this query i'm going to demonstrate you how to find top three salaries in ORACLE 11g step by step.
Views: 4336 OCP Technology
Oracle - PL-SQL Function in Hindi
 
06:32
In this video i'm going to discus on oracle pl/sql function, how to create new your own function in Oracle, in Hindi Language.
Views: 5259 OCP Technology
TUTORIAL-3 Select, functions like min, max, count, sum, avg in oracle database
 
07:47
select, functions like min, max, count, sum, avg in oracle database. Demonstration of working on a table and data in it. Please like and subscribe us.
Views: 117 Let's Learn Pro
PL-SQL Functions
 
09:43
This class of PL-SQL explains functions and its features with examples, stored procedures, difference between functions and SP and creating local functions within stored procedures.
Views: 76209 learningdom
PL-SQL Procedure, How to Create Procedure, Calling Procedure in Oracle 11g Database
 
10:56
PL-SQL Procedure, How to Create Procedure, Calling Procedure in Oracle 11g Database PL-SQL tutorial for Beginners in Hindi and English
ROWID VS ROWNUM IN ORACLE
 
09:21
This Video explains the difference between ROWID and ROWNUM using real project examples. ROWID provides the unique physical address where the row is being stored. ROWNUM indicates the order in which the data was returned from the select query.
Views: 3398 Tech Coach
Part 1   How to find nth highest salary in sql
 
11:45
Link for all dot net and sql server video tutorial playlists http://www.youtube.com/user/kudvenkat/playlists Link for slides, code samples and text version of the video http://csharp-video-tutorials.blogspot.com/2014/05/part-1-how-to-find-nth-highest-salary_17.html This is a very common SQL Server Interview Question. There are several ways of finding the nth highest salary. By the end of this video, we will be able to answer all the following questions as well. How to find nth highest salary in SQL Server using a Sub-Query How to find nth highest salary in SQL Server using a CTE How to find the 2nd, 3rd or 15th highest salary Let's use the following Employees table for this demo Use the following script to create Employees table Create table Employees ( ID int primary key identity, FirstName nvarchar(50), LastName nvarchar(50), Gender nvarchar(50), Salary int ) GO Insert into Employees values ('Ben', 'Hoskins', 'Male', 70000) Insert into Employees values ('Mark', 'Hastings', 'Male', 60000) Insert into Employees values ('Steve', 'Pound', 'Male', 45000) Insert into Employees values ('Ben', 'Hoskins', 'Male', 70000) Insert into Employees values ('Philip', 'Hastings', 'Male', 45000) Insert into Employees values ('Mary', 'Lambeth', 'Female', 30000) Insert into Employees values ('Valarie', 'Vikings', 'Female', 35000) Insert into Employees values ('John', 'Stanmore', 'Male', 80000) GO To find the highest salary it is straight forward. We can simply use the Max() function as shown below. Select Max(Salary) from Employees To get the second highest salary use a sub query along with Max() function as shown below. Select Max(Salary) from Employees where Salary [ (Select Max(Salary) from Employees) To find nth highest salary using Sub-Query SELECT TOP 1 SALARY FROM ( SELECT DISTINCT TOP N SALARY FROM EMPLOYEES ORDER BY SALARY DESC ) RESULT ORDER BY SALARY To find nth highest salary using CTE WITH RESULT AS ( SELECT SALARY, DENSE_RANK() OVER (ORDER BY SALARY DESC) AS DENSERANK FROM EMPLOYEES ) SELECT TOP 1 SALARY FROM RESULT WHERE DENSERANK = N To find 2nd highest salary we can use any of the above queries. Simple replace N with 2. Similarly, to find 3rd highest salary, simple replace N with 3. Please Note: On many of the websites, you may have seen that, the following query can be used to get the nth highest salary. The below query will only work if there are no duplicates. WITH RESULT AS ( SELECT SALARY, ROW_NUMBER() OVER (ORDER BY SALARY DESC) AS ROWNUMBER FROM EMPLOYEES ) SELECT SALARY FROM RESULT WHERE ROWNUMBER = 3
Views: 947695 kudvenkat
PL-SQL Functions, How to Create PL SQL Function using Table in Oracle 11g Database
 
11:07
PL-SQL Functions, How to Create PL SQL Function using Table in Oracle 11g Database PL-SQL tutorial for Beginners in Hindi and English
FUNCTIONS IN ORACLE PL/SQL (basic to advance examples)
 
19:50
This video is to understand how to create an oracle pl/sql function, the video demonstrates the use of in, out and in out parameter types. The video also explains on how to call a function from a pl/sql block and from a select statement.
Views: 4304 Kishan Mashru
Oracle - SQL - Character Functions
 
08:46
Oracle - SQL - Character Functions Watch more Videos at https://www.tutorialspoint.com/videotutorials/index.htm Lecture By: Mr. Anadi Sharma, Tutorials Point India Private Limited.
REF CURSOR AND SYS_REFCURSOR IN ORACLE PL/SQL WITH EXAMPLE
 
25:07
This video explains about ref cursor in oracle pl/sql, what are ref cursors, how are ref cursor different from simple cursors, what are the advantages of using a ref cursor etc. The video demonstrates proper and easy to understand examples on ref cursor.
Views: 10869 Kishan Mashru
DECODE FUNCTION IN ORACLE SQL
 
09:36
This video tutorial explains with proper example on how to write a decode statement, this video also demonstrates how the decode statement behaves on null values and implicit datatype conversion that happens in a decode statement.
Views: 2695 Kishan Mashru
SQL with Oracle 10g XE - Using the MIN, MAX, and AVG Functions
 
04:48
In this video I use the MIN, MAX, and AVG functions to generate the minimum, maximum, and average vales of a column. When using these functions be sure to include the column you wish to perform the function on in parenthesis. You can also use the WHERE keyword to limit the function to only those records that meet your criteria. This video is part of a series of videos with the purpose of learning the SQL language. For more information visit Lecture Snippets at http://lecturesnippets.com.
Views: 4638 Lecture Snippets
How to return multiple values from a function in oracle pl/sql ? (without using out parameter)
 
14:19
This video demonstrates how a function can return multiple values to the calling environment, but without using multiple out parameters, the video shows an example on how we can create a object, a nested table based on the object and then returning the nested table type from the function.
Views: 20580 Kishan Mashru
Nth Highest salary employee Details | SQL | Oracle | PL Sql
 
03:21
Find nth Highest Salary SQL | Oracle/SQL
Views: 3122 Online Pl Sql
Oracle Tutorial || Oracle|Sql Functions Part - 1 by basha
 
33:25
DURGASOFT is INDIA's No.1 Software Training Center offers online training on various technologies like JAVA, .NET , ANDROID,HADOOP,TESTING TOOLS ,ADF,INFORMATICA,TABLEAU,IPHONE,OBIEE,ANJULAR JS, SAP... courses from Hyderabad & Bangalore -India with Real Time Experts. Mail us your requirements to [email protected] so that our Supporting Team will arrange Demo Sessions. Ph:Call +91-8885252627,+91-7207212428,+91-7207212427,+91-8096969696. http://durgasoft.com http://durgasoftonlinetraining.com https://www.facebook.com/durgasoftware http://durgajobs.com https://www.facebook.com/durgajobsinfo......
P#2 Max salary from each department in Oracle SQL Database -Interview question
 
02:40
Interview question on Oracle SQL ,how to find Maximum salary / Total from each department in Oracle SQL Database which is group by based question oracle interview questions and answers for experienced it will cover the following interview question 1) How to find total number of employees from each department 2) How to find minimum salary from each department 3) How to find average salary from each department 4) How to find maximum salary from each department 5) How to find sum of salary from each department This series is based on Oracle interview question and we will cover most asked interview question in Oracle SQL Database Interview question face by fresher as well as an experienced software engineer frequently asked question for fresher will cover following things 1)advance Oracle SQL Database interview question as well 2)interview questions and answers on oracle SQL database 3)interview questions and answers for freshers 4)oracle interview questions and answers for experienced 5)interview preparation 6)sql interview questions 7)sql telephonic interview 8) oracle interview questions and answers for 3 years experience follow me on: Facebook Page: https://www.facebook.com/LrnWthr-319371861902642/?ref=bookmarks Contacts Email: [email protected] Instagram: https://www.instagram.com/equalconnect/ Twitter: https://twitter.com/LrnWthR #equalConnectCoach #rakeshmalviya #interviewquestion
Views: 124 EqualConnect Coach
37. Conversion Functions To Char, To Date, NVL, Decode in PL/SQL Oracle
 
10:19
In this video you will learn about Conversion Functions To Char, To Date, NVL, Decode in PL/SQL Oracle. For Support =========== Email: [email protected] Contact Form: http://www.learninhindi.com/home/contact Our Social Media ================ Facebook: https://www.facebook.com/LearnInHindi Twitter: https://twitter.com/LearnInHindi For Training & Videos ===================== For more videos and articles visit: http://www.learninhindi.com Free Java Programming In Hindi Course ===================================== https://www.youtube.com/playlist?list=PLOZ3jentlCDAwwhMyoLISrxkXTADGp7PH Free Oracle PL/SQL Programming In Hindi Course ============================================== https://www.youtube.com/playlist?list=PLB5DA82419C2D99B6 Free C Programming In Hindi Course ================================== https://www.youtube.com/playlist?list=PLOZ3jentlCDAxKpBLMWogxSdy6BZcsAJq Trips & Tricks Channel ====================== https://www.youtube.com/channel/UCGmLfkuCo-3lHHJXRJ9HUMw Programming in Hindi Channel ============================ https://www.youtube.com/channel/UCudElIDgwNrybeAvXIy1HZQ
Views: 10494 ITORIAN
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: 30539 Tech Jago
SQL: pseudo columns (Rowid/Rownum)
 
05:54
In this tutorial, u'll learn the difference between rowid & rownum..
Views: 31642 radhikaravikumar
Oracle - SQL - Functions
 
03:45
Oracle - SQL - Functions Watch more Videos at https://www.tutorialspoint.com/videotutorials/index.htm Lecture By: Mr. Anadi Sharma, Tutorials Point India Private Limited.
ORACLE SQL AND PL/SQL INTERVIEW QUESTION : DELETE DUPLICATE RECORDS FROM  A TABLE(3 ways)
 
13:15
This video tutorial demonstrates about how we can delete duplicate records from a table, the video shows 3 different ways to delete duplicate record from a table, one using Group by, second one by using correlated joins and third on by using rownum analytical function You can get the code from our website http://oracleplsqlblog.com/FullBlog/FullBlog/21
Views: 4956 Kishan Mashru
Урок9.PL SQL.Функции
 
06:23
Функция — это подпрограмма на языке ORACLE PL SQL, которая вычисляет значения и возвращает результат вычисления. У функции есть уникальное в рамках схемы БД имя и набор параметров. Функцию можно вызывать из другой процедуры или функции, а также из анонимного PL SQL блока. Oracle PL SQL. учебная среда https://apex.oracle.com/pls/apex/f?p=4550:1:103440124..::::: схема: SQLADV польз: student1 пароль: student1 будут работать (student2/ student2, student3/ student3 .... student11/ student11) меню SQL Workshop , SQL Command или используйте http://sqlfiddle.com/ скрипт бд для загрузки в sqlfiddle http://sqladv.ru/dev/sql.txt урок и задания http://sqladv.ru/dev/plsql/l9.txt
oracle mysql select max and return multiple values
 
06:25
Code and details: http://blog.softhints.com/oracle-mysql-select-max-and-return-multiple-values/ another example on max N per group http://blog.softhints.com/mysql-select-n-max-values-per-group/ Mysql group by column and return N max/min rows per group: * get max per group * get minimum per group * use additional constraints * return N per group --------------------------------------------------------------------------------------------------------------------------------------------------------------- If you really find this channel useful and enjoy the content, you're welcome to support me and this channel with a small donation via PayPal and Bitcoin. PayPal donation https://www.paypal.me/fantasyan Bitcoin: 1DBZu6N9JTpRDdc9QChLZnX3v2iVRaQ4ym Programming is a fun! :) Site: www.softhints.com Facebook: www.facebook.com/Softhints/ Twitter: www.twitter.com/SoftwareHints
Views: 37 Softhints
How to find Top Three Salaries from employee table ?
 
07:27
Hello guys in this video i m showing to you how to retrieve the top most salary from table. #TopThreeSalaries Oracle database Unbeatable,Unbreakable Platform..
Views: 7839 Oracle World
SQL Tutorial : Difference Between Translate &  Replace in SQL Oracle
 
06:36
SQL Tutorial : Difference Between Translate & Replace 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: 896 TechLake
PL/SQL Concepts (Hindi+English)
 
08:54
Plz like Subscribe and share your view
Oracle SQL, PL/SQL, Select Kullanımı ve Eğitimi 1 - Select Where Order By Group By Having Distinct
 
27:19
Oracle SQL, PL/SQL, Select Kullanımı ve Eğitimi 1 - Select, Where, Order By, Group By, Having, Distinct, oracle select statement, oracle select education, PL/SQL Select, Where, Order By, Group By, Having, Distinct, PL/SQL
Views: 399 Taner TOPCU