Home
Search results “Oracle sql not in select”
EXIST Function in SQL
 
08:04
Join Discussion: http://www.techtud.com/video-lecture/exist-function-sql IMPORTANT LINKS: 1) Official Website: http://www.techtud.com/ 2) Virtual GATE: http://virtualgate.in/login/index.php Both of the above mentioned platforms are COMPLETELY FREE, so feel free to Explore, Learn, Practice & Share! Our Social Media Links: Facebook Page: https://www.facebook.com/techtuduniversity Facebook Group: https://www.facebook.com/groups/virtualgate Google+ Page: https://plus.google.com/+techtud/posts Last but not the least, SUBSCRIBE our YouTube channel to stay updated about the regularly uploaded new videos.
Views: 35783 Techtud
Oracle Database11g tutorials 5:  how to retrieve Data Using SQL SELECT statement || SQL tutorials
 
05:13
This SQL tutorial and Oracle database 11g tutorial for beginners will show how to retrieve data using SQL SELECT statement. Tool used in this tutorial is SQL developer. This tutorial series is part of SQL expert exam certification training. if you are preparing for SQL certification you can use my tutorials. This SQL Tutorial is a part of free training. Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage https://copy.com?r=j7eYO7 You can download the Script which is used in this SQL tutorial from this link https://copy.com/yDQ46Tb64efm Contacts Email [email protected] Twitter https://twitter.com/rebellionrider Instagram http://instagram.com/RebellionRider Facebook. https://www.facebook.com/imthebhardwaj Linkedin. in.linkedin.com/in/mannbhardwaj/ Thanks for linking, commenting, sharing and watching more of our videos This is Manish from The Code makers
Views: 194206 Manish Sharma
Oracle SQL Video Tutorial 1: SELECT Statement
 
10:05
Oracle SQL Video Tutorial: SELECT Statement . In This video we explained how to use select statement. "oracle as" "what is oracle" "sql and pl sql" "pl sql pl sql" "pl sql &" "& pl sql" "pl sql and" "pl sql and sql" "oracle to sql" "to sql oracle" "sql to oracle" "oracle 10g" "oracle 11g" "oracle database" "database oracle" "oracle data" "oracle download" "download oracle" "tutorial on sql" "tutorial for sql" "sql tutorial for" "sql tutorial" "sql and tutorial" "visual basic tutorial" "oracle 9i" "oracle on windows" "linux oracle" "oracle and linux" "oracle linux" "oracle on linux" "pl oracle" "oracle forms" "oracle sql pl" "oracle pl sql" "oracle dba" "tutorial for oracle" "tutorial of oracle" "tutorial on oracle" "tutorial in oracle" "oracle tutorial" "tutorial oracle" "oracle free" "free oracle" "oracle apex" "tutorials for sql" "sql tutorials" "tutorials on sql" "oracle certification" "certification oracle" "oracle software"
Views: 13977 Just Channel
ORACLE SQL INTERVIEW QUESTION : HOW TO SELECT ODD OR EVEN ROWS FROM A TABLE IN ORACLE
 
03:52
This video tutorial answers the frequently asked interview question, how to select only odd or even records in oracle sql, after watching this video you will understand more on the topic and will be able to answer this interview question with a lot of confidence.
Views: 4041 Kishan Mashru
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: 148734 Michael Fudge
SQL DISTINCT Within a SELECT - Retrieving Unique Values
 
03:41
Jamie King of Neumont University demonstrating use of DISTINCT within a SQL SELECT command.
Views: 22379 Jamie King
Sql query to select all names that start with a given letter without like operator
 
03:02
Text Article http://csharp-video-tutorials.blogspot.com/2017/01/sql-query-to-select-all-names-that.html Slides http://csharp-video-tutorials.blogspot.com/2017/01/sql-query-to-select-all-names-that_31.html SQL Server Interview Questions and Answers text articles & slides http://csharp-video-tutorials.blogspot.com/2014/05/sql-server-interview-questions-and.html SQL Server Interview Questions and Answers playlist https://www.youtube.com/playlist?list=PL6n9fhu94yhXcztdLO7i6mdyaegC8CJwR 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 In this video we will discuss writing a SQL query to retrieve all student names that start with letter 'M' without using the LIKE operator. If the interviewer has not mentioned not to use LIKE operator, we would have written the query using the LIKE operator as shown below. SELECT * FROM Students WHERE Name LIKE 'M%' We can use any one of the following 3 SQL Server functions, to achieve exactly the same thing. CHARINDEX LEFT SUBSTRING The following 3 queries retrieve all student rows whose Name starts with letter 'M'. Notice none of the queries are using the LIKE operator. SELECT * FROM Students WHERE CHARINDEX('M',Name) = 1 SELECT * FROM Students WHERE LEFT(Name, 1) = 'M' SELECT * FROM Students WHERE SUBSTRING(Name, 1, 1) = 'M'
Views: 56755 kudvenkat
Find Duplicate Rows in SQL - Select Statement Tutorial
 
02:06
Find duplicate row values in a field or multiple fields in SQL Server table with this tutorial. Do this for one column, or multiple columns. Uses SQL Server Management Studio for the demonstration.
Views: 42757 Edward Kench
PL/SQL tutorial 15: DML Trigger With Before Insert, Update and Delete DML Examples
 
09:17
PL/SQL Tutorial 15 explaining DML Trigger with examples such as Before Insert, Update and Delete in Detail. ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/dml-triggers Previous Tutorial ► Trigger Intro : https://youtu.be/R3fvX_xf5P4 ► SELECT-INTO : https://youtu.be/F5eMJhwmCQs ►IF-THEN-ELSIF: https://youtu.be/aW9XgUHSr0I ------------------------------------------------------------------------- ►►►Let's Get Free Uber Cab◄◄◄ Use Referral Code UberRebellionRider and get $20 free for your first ride. ------------------------------------------------------------------------- ►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 https://www.facebook.com/imthebhardwaj http://instagram.com/rebellionrider https://plus.google.com/+Rebellionrider http://in.linkedin.com/in/mannbhardwaj/ http://rebellionrider.tumblr.com/ http://www.pinterest.com/rebellionrider/ You can also Email me at for E-mail address please check 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: 101705 Manish Sharma
SQL for Beginners (Part 1) : The SELECT List
 
03:33
The first part of a mini-series of videos showing the basics of SQL. In this episode, we take a look at the type of things you are likely to see in the SELECT list of queries. For more information see: https://oracle-base.com/articles/misc/sql-for-beginners-the-select-list Website: https://oracle-base.com Blog: https://oracle-base.com/blog Twitter: https://twitter.com/oraclebase Cameo by Edelweiss Kammermann : Blog: http://www.rittmanmead.com/author/edel-kammerman/ Twitter: https://twitter.com/EdelweissK Cameo appearances are for fun, not an endorsement of the content of this video.
Views: 5086 ORACLE-BASE.com
Oracle Rowid, RowNum and row_number
 
06:44
Oracle Rowid, RowNum and row_number... Explained in detailed...
Views: 5895 CONNECT TO LEARN
The SQL EXISTS clause
 
08:52
How to use the EXISTS clause in SQL. For beginners.
Views: 22660 Database by Doug
Nested Queries | SQL | Tutorial 18
 
10:23
Giraffe Academy is rebranding! I've decided to re-focus the brand of this channel to highlight myself as a developer and teacher! The newly minted Mike Dane channel will have all the same content, with more to come in the future! Source Code - http://www.mikedane.com/databases/sql. This video is one in a series of videos where we'll be looking at database management basics and SQL using the MySQL RDBMS. The course is designed for beginners to SQL and database management systems, and will introduce common database management topics. Throughout the course we'll be looking at various topics including schema design, basic C.R.U.D operations, aggregation, nested queries, joins, keys and much more. If you’re enjoying Giraffe Academy and want to invest in our future, consider leaving a contribution http://www.mikedane.com/contribute Links: Website - http://www.mikedane.com/ Facebook - https://www.facebook.com/giraffeacademy/ Twitter - https://twitter.com/GiraffeAcademy
Views: 4931 Mike Dane
Oracle SQL PLSQL 12C Tutorial 8 - SELECT Command , Fetch Data from Table
 
09:41
This Video Tutorial Will Describe how to select or retrieve values or data into a table in oracle 12C version. This 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. Whenever you create a new table in oracle, you need to insert some data into that table otherwise that table is not usable. Example to select data, to update data and delete data, you first need to insert some data. Then this part comes where you select the data from the table. Full Syntax will be given in this video tutorial about how to select records from oracle database table. Along with the live example to select records. All the keywords, format, mandatory clauses etc are described in this video.
Create new connection with new user in Oracle SQL Developer
 
10:28
This video shows you how to create a new connection using a new user account (other than the system user account) in Oracle SQL Developer, so that you have a clean workspace without all the clutter of system tables. It is NOT a general introduction to using Oracle SQL Developer.
Views: 342441 Chitu Okoli
Formatting your Oracle Query Results Directly to CSV
 
03:02
How to get Oracle SQL Developer to automatically format your query results to CSV, HTML, JSON, Insert statements, and more.
Views: 42199 Jeff Smith
Oracle SQL Lecture 28: IS NULL and IS NOT NULL
 
03:19
Oracle SQL: IS NULL and IS NOT NULL https://www.youtube.com/channel/UCnBpiBIOtRgMsk4G7Ri1jbQ
Views: 729 Oracle SQL
SQL Aggregation queries using Group By, Sum, Count and Having
 
10:01
From SQL Queries Joes 2 Pros (Vol2) ch4.1. Learn up to write aggregated queries.
Views: 169023 Joes2Pros SQL Trainings
Understanding the use of GROUP BY clause in SQL
 
04:39
Join discussion: http://www.techtud.com/video-lecture/understanding-group-clause-sql IMPORTANT LINKS: 1) Official Website: http://www.techtud.com/ 2) Virtual GATE: http://virtualgate.in/login/index.php Both of the above mentioned platforms are COMPLETELY FREE, so feel free to Explore, Learn, Practice & Share! Our Social Media Links: Facebook Page: https://www.facebook.com/techtuduniversity Facebook Group: https://www.facebook.com/groups/virtualgate Google+ Page: https://plus.google.com/+techtud/posts Last but not the least, SUBSCRIBE our YouTube channel to stay updated about the regularly uploaded new videos.
Views: 66999 Techtud
Oracle SQL PLSQL 12C Tutorial 8   SELECT Command , Fetch Data from Table
 
09:41
This Video Tutorial Will Describe how to select or retrieve values or data into a table in oracle 12C version. This 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. Whenever you create a new table in oracle, you need to insert some data into that table otherwise that table is not usable. Example to select data, to update data and delete data, you first need to insert some data. Then this part comes where you select the data from the table. Full Syntax will be given in this video tutorial about how to select records from oracle database table. Along with the live example to select records. All the keywords, format, mandatory clauses etc are described in this video.
Views: 85 game hounds
9-Oracle Database - SQL - select conditions between in is null logical operators and or not.avi
 
21:15
Oracle Database - SQL - select where compasion operators conditions between in is null logical operators and or not
Views: 1335 Adel Sabour
Learning PL/SQL programming
 
29:21
Download the session ppts @ https://drive.google.com/file/d/0B_2D199JLIIpLXp5cm9QMFpVS00/view?usp=sharing 3:05 - Procedures 6:48 - Cursors 15:13 - Functions 16:36 - Triggers 21:35 - Package 23:59 - Exceptions
Views: 134210 BBarters
SQL SELECT - 13 - SUBCONSULTAS: EXISTS
 
03:57
Todo lo que necesitas en: http://tutorialesnet.com Redes Sociales: http://tutorialesnet.com/twitter http://tutorialesnet.com/facebook
Views: 6837 TutorialesNET
IS NOT NULL, IS NULL, NVL FUNCTION in oracle sql
 
03:04
Oracle sql tutorial, How to select, retrieve rows with null values, not null values and NVL function in oracle SQL
Best Way to Write Basic SQL Queries
 
13:33
SQL Server Query writing strategies is something I have yet to find in any book. When enthusiastic SQL students do this, they experience a revelation. The number of errors drops significantly and the speed at writing complex queries increases immediately. Knowing how to narrow down what we are looking for amongst a vast list of choices helps immensely. Grabbing the right tables first and then the fields second is akin to grabbing the right menu before ordering an item from it. In fact, one student named Tim took this back to his team of SQL developers and they immediately implemented this process. We are all used to following steps. Most of the time, actions are sequential from top to bottom or left to right. Other times we complete things in phases. The two phases we are going to use in this exercise apply to joining tables. This is easy to implement as we only need remember to organize first and clean up second. When visiting a new restaurant, we will ask to see the menu, because we want to see all they have to offer. The odds are that we might be interested in half of the items, but only need a few dishes for our group at the table. Looking at the menu is like starting a query with a ‘SELECT *’ statement. Once we have looked at all the fields, we narrow our choice(s) to only the items we want at the time. Sometimes restaurants have multiple menus. My favorite restaurant has a kids’ menu, an adult menu, a gluten-free menu and a drink menu. These menus were each gathered at our table. Ultimately, in my head, a selection was narrowed to what was needed. Phase I: Organize. When building a new query from many tables, we often find ourselves wondering, “Where do I start?” First, lay the steps out by identifying which tables contain the essential data. Second, get all the table joins working with a basic ‘SELECT *’ statement. Third, add any basic filtering criteria. Phase II: Itemize. Once all joins and criteria, such as SELECT, FROM and WHERE are working, we are ready for Phase II. This entails going back and changing our ‘SELECT *’ to an itemized SELECT field list as the final step. Let’s explore how this two-phase process of Organize and then Itemize can be a big time-saver. We are going to use one of the challenges from the last lab. In Lab 3.2 (Outer Joins), Skill Check 2, we needed to get four fields from two different tables. If we were to list all four desired fields and test one table at time, we will get an error as seen on the right side of the figure below. In the figure below we write a SELECT statement and part of the FROM clause. When completed, the FROM clause will have two tables, but for now we just want to get the Location table working. By using the ‘SELECT *’ strategy, we remove any possible errors from line 1. From there, we can focus on the more complicated logic used for joining tables together. We can add tables one at a time until everything is working. This is the Organize phase. NOTE: SELECT * never results in an Error message stating “invalid column name”, however; a SELECT list with itemized field(s) can have this error. After our query is organized and working, we can go back and itemize the SELECT field list to display only the fields that are necessary. This is done during Phase II (Itemize). The steps for this system are broken down as follows: Since SELECT is always the first statement in a query, it’s natural to want to write the field names before writing the FROM clause. However; we can save time and trouble by using the ‘*’ until the entire query is working properly. When this is complete, it is very easy to itemize the field list, with the confidence of knowing it will not cause any problems. Exercise: Simple membership for a club: Table1 (id_Member,name_Member, email_member, title, age, company) Table2 (id_Club,club_name, club_Location, address) Table3 (id_club, id_member,membership_date) Q1: Show all member names, email, age, and company from Table1 Q2: Show all club name, location, and address data Q3: Show member name, club name, club location (hint: Use joins and all 3 tables) You can find all other classes related to this video here: http://www.joes2pros.com/joes2pros/Course/Introduction_To_Microsoft_SQL_Server Enroll Today & Get the First Month for only $1! Use code: YOUTUBE1
Views: 213953 Joes2Pros SQL Trainings
Oracle SQL Developer Tutorial For Beginners  84   SELECT EVERYTHING
 
01:21
Oracle SQL Developer Tutorial For Beginners Series. This course introduces Oracle SQL Development for its subscribers. Currently this is based on Oracle 12c. The test environment is in Windows 10.
Views: 749 Sam Dhanasekaran
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: 39307 SQL with Manoj
SQL with Oracle 10g XE - Using AND and OR with SELECT
 
04:29
In this video I use both AND and OR with the SELECT command to query data from a table. I show the difference between a simple search using AND or OR within the search. 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: 3949 Lecture Snippets
06 of 15 SQL Basics with Oracle - SELECT ... FROM ... WHERE
 
06:42
This video extends the simple SELECT .... FROM command with the WHERE clause. This allows you to filter the data retrieved from a table, such as viewing only employees in a particular department or viewing only students with a particular major. (6 of 15) There is also an "Advanced SQL" series. (Search for "databasemec" for tutorials using SQL Server.)
Views: 2629 Jennifer Kreie
SQL Joins Tutorial for Beginners - Inner Join, Left Join, Right Join, Full Outer Join
 
18:04
Learn how to create SQL Joins. The first 10 minutes teach you the basics. Inner Join, Left Outer Join, Right Outer Join, and Full Outer Join. The second 10 minutes show you are few techniques that will help you as you start building joins. READ THE ORIGINAL ARTICLE WITH THE TABLE SCRIPS http://www.sqltrainingonline.com/sql-joins-tutorial-for-beginners/ YOUTUBE NEWS UPDATES http://www.youtube.com/user/sqltrainingonline VISIT SQLTRAININGONLINE.COM FOR TONS MORE VIDEO NEWS & TIPS http://www.sqltrainingonline.com SUBSCRIBE FOR OTHER SQL TIPS AND NEWS! http://www.youtube.com/subscription_center?add_user=sqltrainingonline SUBSCRIBE TO OUR EMAIL LIST! http://www.sqltrainingonline.com LET'S CONNECT! Facebook: http://facebook.com/SQLTrainingOnline Twitter: http://twitter.com/sql_by_joey Linkedin: http://linkedin.com/in/joeyblue SQLTrainingOnline: http://www.sqltrainingonline.com
Views: 132615 Joey Blue
Oracle SQL Developer: Query Builder Demo
 
08:13
How to build queries with your mouse versus the keyboard.
Views: 71906 Jeff Smith
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: 62924 SQL with Manoj
ORDER BY Clause in Oracle | Oracle Tutorials for Beginners
 
04:37
Oracle Tutorials for Beginners ORDER BY Clause In Oracle ORDER BY Clause in SQL Oracle Tutorials for Beginners Oracle SQL Introduction #Oracle Tutorisla for Beginners Oracle for Beginners Oracle plsql tutorial for Beginners Oracle plsql tutorial for Beginners Oracle plsql tutorial for Beginners ORDER BY in Oracle SQL ORDER BY in Oracle SQL ORDER BY in Oracle SQL NULLS FIRST in Oracle NULLS FIRST in Oracle NULLS LAST in Oracle NULLS LAST in Order by Clause how order by clause works in oracle oracle order by date oracle sort varchar2 alphabetically oracle order by case multiple columns oracle sql order by specific values order by in oracle w3schools sql order by multiple columns oracle order by column not in select order by in oracle w3schools oracle order by multiple columns oracle sql order by specific values how order by clause works in oracle oracle order by date oracle order by group by sql order by alphabetical order by sql
Views: 418 Oracle PL/SQL World
Oracle Database11g tutorials 14 : How to CREATE TABLE using sql developer and command prompt
 
08:36
Oracle Database11g tutorials 14 How to Create table using command prompt and Create table using sql developer Blog Link http://bit.ly/1TkY4Oe Time Line 0:25 Introduction of Tables in Database 1:03 What is Create Table (Introduction of create table) 1:30 Syntax of Create Table 2:08 How to create table using Command Prompt 4:55 How to create table using SQL Developer Links for Oracle Database tutorials 4: database connectivity using SQL developer and command prompt http://youtu.be/wSqoXRlXDUU You can have indepth knowledge about SQL create table here http://www.rebellionrider.com/sql-create-table.html Tool used in this tutorial is command prompt. This tutorial series is part of SQL expert exam certification training. if you are preparing for SQL certification you can use my tutorials. This SQL Tutorial is a part of free training. Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage https://copy.com?r=j7eYO7 Contacts E-Mail [email protected] Twitter https://twitter.com/rebellionrider Instagram http://instagram.com/rebellionrider Facebook. https://www.facebook.com/imthebhardwaj Linkedin. http://in.linkedin.com/in/mannbhardwaj/ Thanks for linking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com Today in this oracle database tutorial we will see How to CREATE A TABLE. if we have to define a table in layman language then we can say that Tables are just a collection of Rows and Columns but In RDBMS tables are database objects which help in organizing data into ROWS and COLUMNS. We can also say that SQL tables are kind of data structure which are used by database for efficient storage of data. To create a table in our database we use SQL CREATE TABLE command. SQL CREATE TABLE is a type of DATA DEFINITION LANGUAGE also known as DDL. To Create a table in your schema you will require CREATE TABLE system privilege. In our future videos we will see what are system and object privileges and how to grant them to a user. Today for this video we will be using Sample schema HR which already has all the necessary privileges. Ohk Let's see the syntax. CREATE TABLE table name ( column name1 Data-Type(size), column name2 Data-Type(size), ..... ); CREATE TABLE is an oracle reserved word or say an Oracle key word whereas There are 3 different ways of creating a table in Oracle database. Creating a table using Command Line Interface (CLI) in Oracle database For demonstrating how to create table in oracle database using CLI, I'll be using Command prompt. Thats how we create table using command prompt. you can check your table structure by DESCRIBE command for that just write DESC and your table name. Like this Another way of creating a table is by using Graphic user interface (GUI) in Oracle database To demonstrate how to create table using GUI we will use SQL developer. Lets open our SQL developer I am connected to HR schema if you do not know how to create a connection to database using SQL developer please watch my oracle database tutorial 4 that explains database connectivity using SQL developer and command prompt. Link for this video is in the description below. So lets create a table. Creating a table using SQL developer is very easy we do not have to fire any query here. Let's start First of all right click on your connection in which you want to create a table and choose schema browser. This will open a separate schema browser pane or you can expend your connection by clicking this + sign and then right click on table and choose New Table. However I prefer working with schema browser so let's skip to schema browser pane here from the first drop-down list you can choose connection name and in the second drop down list you can choose what database objects you want to work with we want to create a table thus I'll choose table and then click this arrow here and choose option for new table Ok we have created a table wizard first of all give a unique name to your table and add some column as well. For this, click the green plus button. Now we already have a column so give it some name. Also choose a datatype from the list and specify any size you can check this not null column if in case you want to make this a mandatory column you can also specify default value and constraint If you want to make this column a primary key you can click here In my future video i'll show you what are these constraints and different ways of applying them on a column in a table. for this video we will concentrate on create table only so when you are done with all your columns click ok Thats your table You can double click on your table here and can see its structure. Thats it
Views: 175617 Manish Sharma
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: 885502 kudvenkat
Over clause in SQL Server
 
09:13
over partition by in sql server 2008 sql server over clause partition partition by clause in sql server 2008 over partition by clause in sql In this video we will discuss the power and use of Over clause in SQL Server. The OVER clause combined with PARTITION BY is used to break up data into partitions. Syntax : function (...) OVER (PARTITION BY col1, Col2, ...) The specified function operates for each partition. For example : COUNT(Gender) OVER (PARTITION BY Gender) will partition the data by GENDER i.e there will 2 partitions (Male and Female) and then the COUNT() function is applied over each partition. Any of the following functions can be used. Please note this is not the complete list. COUNT(), AVG(), SUM(), MIN(), MAX(), ROW_NUMBER(), RANK(), DENSE_RANK() etc. Example : 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 Write a query to retrieve total count of employees by Gender. Also in the result we want Average, Minimum and Maximum salary by Gender. This can be very easily achieved using a simple GROUP BY query as show below. SELECT Gender, COUNT(*) AS GenderTotal, AVG(Salary) AS AvgSal, MIN(Salary) AS MinSal, MAX(Salary) AS MaxSal FROM Employees GROUP BY Gender What if we want non-aggregated values (like employee Name and Salary) in result set along with aggregated values You cannot include non-aggregated columns in the GROUP BY query. SELECT Name, Salary, Gender, COUNT(*) AS GenderTotal, AVG(Salary) AS AvgSal, MIN(Salary) AS MinSal, MAX(Salary) AS MaxSal FROM Employees GROUP BY Gender The above query will result in the following error : Column 'Employees.Name' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause One way to achieve this is by including the aggregations in a subquery and then JOINING it with the main query as shown in the example below. Look at the amount of T-SQL code we have to write. SELECT Name, Salary, Employees.Gender, Genders.GenderTotals, Genders.AvgSal, Genders.MinSal, Genders.MaxSal FROM Employees INNER JOIN (SELECT Gender, COUNT(*) AS GenderTotals, AVG(Salary) AS AvgSal, MIN(Salary) AS MinSal, MAX(Salary) AS MaxSal FROM Employees GROUP BY Gender) AS Genders ON Genders.Gender = Employees.Gender Better way of doing this is by using the OVER clause combined with PARTITION BY SELECT Name, Salary, Gender, COUNT(Gender) OVER(PARTITION BY Gender) AS GenderTotals, AVG(Salary) OVER(PARTITION BY Gender) AS AvgSal, MIN(Salary) OVER(PARTITION BY Gender) AS MinSal, MAX(Salary) OVER(PARTITION BY Gender) AS MaxSal FROM Employees Text version of the video http://csharp-video-tutorials.blogspot.com/2015/09/over-clause-in-sql-server.html Slides http://csharp-video-tutorials.blogspot.com/2015/09/over-clause-in-sql-server_29.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: 84784 kudvenkat
08 of  13 - Oracle APEX 5 - List of values (LOV) for a field in a form; display a hidden column
 
13:22
A new series using APEX 18.1 is now available. https://youtu.be/vgrkiIpJEiQ This is one in a series of videos about creating an application using Oracle APEX 5. In this video we create two lists of values (LOVs) in the Shared Components section of our application. We use each LOV in place of a field in a form. We see how APEX will help us write the SQL for a LOV. The difference between a "display value"and a "return value"is discussed. Finally, we display the primary key field in a form, which APEX hides by default. See the primary key field in a form can be helpful during application development. SQL scripts for this series are available to download at: http://db.kreie.net
Views: 36477 Jennifer Kreie
Oracle Database tutorials 4:  database connectivity using SQL developer and command prompt
 
09:19
Blog Link: http://bit.ly/how-to-create-new-connection-in-sql-developer Wishlist: http://bit.ly/wishlist-amazon This SQL tutorial and Oracle database 11g tutorial for beginners will show how to connect to database either on a local machine or on a machine in your LAN using ip address. Tool used in this tutorial is SQL developer & command prompt. This tutorial series is part of SQL expert exam certification training. If you are preparing for SQL certification you can use my tutorials. This SQL Tutorial is a part of free training. Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage https://copy.com?r=j7eYO7 Contacts Email [email protected] Twitter https://twitter.com/rebellionrider Instagram http://instagram.com/RebellionRider Facebook. https://www.facebook.com/imthebhardwaj Linkedin. in.linkedin.com/in/mannbhardwaj/ Thanks for linking, commenting, sharing and watching more of our videos The Code makers
Views: 275314 Manish Sharma
09 of 15 SQL Basics with Oracle - Using IN, NOT IN, NULL and NOT NULL
 
05:02
This video shows how to use the IN clause as an alternative to using the OR operators. The IN clause is more compact--it's easier to type and read than multiple OR criteria. Examples of checking for NULL and NOT NUL are also given. (9 of 15) There is also an "Advanced SQL" series. (Search for "databasemec" for tutorials using SQL Server.)
Views: 2961 Jennifer Kreie
Oracle SQL Programming Lesson 4 in Jinghpaw Language - Set Operators
 
28:24
Compiling SQL queries using Union, Union All, Intercept, Minus, Where Exists, Where Not Exists Operators against the oracle database tables. Please watch in HD format for better video quality. --append/stack data (union,union all) --UNION removes duplicate rows. --UNION ALL does not remove duplicate rows. --Each SELECT statement within the UNION must have the same number of fields in the result sets with similar data types. select 'foo' as test_column from dual union select 'foo' as test_column from dual; select distinct test_column from (select 'foo' as test_column from dual union all select 'foo' as test_column from dual); Select region_name from regions Union Select region_name from regions; select first_name,last_name,job_id,manager_id,salary,deptment_id from employees where department_id in (20,60); --Union /union all select job_id,manager_id,'DEPT 20' as dept from employees where department_id=20 union all select job_id,manager_id,'DEPT 60' as dept from employees where department_id=60; --intersect returns only the rows common to the results of two queries select 'foo' as test_column from dual intersect select 'foo' as test_column from dual; Select region_name from regions; Select region_name from regions intersect Select region_name from regions; -- minus=except returns the rows from the first query that do not exist in the second query select 'foo' as test_column from dual minus select 'foo' as test_column from dual; Select region_name from regions minus Select region_name from regions; select first_name,last_name,job_id,manager_id,salary,'DEPT 20' as dept from employees where department_id=20 minus select first_name,last_name,job_id,manager_id,salary,'DEPT 60' as dept from employees where department_id=60; --complex compound queries Select department_id, count(*) from employees Where department_id in (20,30,40) Group by department_id; Select department_id, count(*) from employees Where department_id in (20) Group by department_id Union all Select department_id, count(*) from employees Where department_id in (30) Group by department_id Union all Select department_id, count(*) from employees Where department_id in (40) Group by department_id; Select department_id, count(*) from employees Where department_id in (20) Group by department_id intersect Select department_id, count(*) from employees Where department_id in (30) Group by department_id minus Select department_id, count(*) from employees Where department_id in (40) Group by department_id; Select department_id, count(*) from employees Where department_id in (20) Group by department_id Union Select department_id, count(*) from employees Where department_id in (30) Group by department_id Union all Select department_id, count(*) from employees Where department_id in (40) Group by department_id; --where exists, in / not exists, not in select e.last_name, e.department_id, e.salary from employees e where exists (select * from departments d where e.department_id=d.department_id); select e.last_name, e.department_id, e.salary from employees e where e.department_id in (select department_id from departments); select e.last_name, e.department_id, e.salary from employees e where not exists (select * from departments d where e.department_id=d.department_id); select e.last_name, e.department_id, e.salary from employees e where e.department_id not in (select department_id from departments);
Views: 42 Hkau Doi
SQL 017 SELECT WHERE AND, OR, and NOT Multiple Conditions
 
04:43
Explains the SELECT WHERE clause with AND, OR, and NOT connectors for multiple conditions. From http://ComputerBasedTrainingInc.com SQL Course. Learn by doing SQL commands for ANSI Standard SQL, Access, DB2, MySQL, Oracle, PostgreSQL, and SQL Server.
Views: 1630 cbtinc
Select statement in sql server - Part 10
 
21:54
In this video we will learn 1. Select specific or all columns 2. Distinct rows 3. Filtering with where clause. 4. Wild Cards in SQL Server 5. Joining multiple conditions using AND and OR operators 6. Sorting rows using order by 7. Selecting top n or top n percentage of rows Text version of the video http://csharp-video-tutorials.blogspot.com/2012/08/select-statement-part-10.html Slides http://csharp-video-tutorials.blogspot.com/2013/08/part-10-all-about-select.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: 334505 kudvenkat
Oracle SQL Developer Tutorial For Beginners   78   Exam Tip   PROJECTION SELECTION and JOINING
 
01:20
Oracle SQL Developer Tutorial For Beginners Series. This course introduces Oracle SQL Development for its subscribers. Currently this is based on Oracle 12c. The test environment is in Windows 10.
Views: 764 Sam Dhanasekaran
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: 74098 kudvenkat
05 of 15 SQL Basics with Oracle - SELECT ... FROM ....
 
09:09
This video shows the simplest, most commonly used SQL command: SELECT ... FROM. We use SQL Developer to view data from tables in the students-teams database and in the HR database. We see how to specify a schema name for a table and how to count rows in a table without showing detailed data from the table. (5 of 15) There is also an "Advanced SQL" series. (Search for "databasemec" for tutorials using SQL Server.)
Views: 3514 Jennifer Kreie
Part 4   Delete duplicate rows in sql
 
03:26
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-4-delete-duplicate-rows-in-sql.html In this video, we will discuss deleting all duplicate rows except one from a sql server table. SQL Script to create Employees table Create table Employees ( ID int, FirstName nvarchar(50), LastName nvarchar(50), Gender nvarchar(50), Salary int ) GO Insert into Employees values (1, 'Mark', 'Hastings', 'Male', 60000) Insert into Employees values (1, 'Mark', 'Hastings', 'Male', 60000) Insert into Employees values (1, 'Mark', 'Hastings', 'Male', 60000) Insert into Employees values (2, 'Mary', 'Lambeth', 'Female', 30000) Insert into Employees values (2, 'Mary', 'Lambeth', 'Female', 30000) Insert into Employees values (3, 'Ben', 'Hoskins', 'Male', 70000) Insert into Employees values (3, 'Ben', 'Hoskins', 'Male', 70000) Insert into Employees values (3, 'Ben', 'Hoskins', 'Male', 70000) The delete query should delete all duplicate rows except one. Here is the SQL query that does the job. PARTITION BY divides the query result set into partitions. WITH EmployeesCTE AS ( SELECT *, ROW_NUMBER()OVER(PARTITION BY ID ORDER BY ID) AS RowNumber FROM Employees ) DELETE FROM EmployeesCTE WHERE RowNumber ] 1
Views: 329452 kudvenkat
Tutorial#74 Minus operator in Oracle SQL Database| Using Minus Operator in Select Statement
 
07:39
Explaining what is Minus Operator in Oracle SQL and what are the types of set Operators in Oracle SQL database The Minus Operator returns rows from the first Query that are not Present in the Second Query, Set operators are used to join the results of two or more SELECT statements, The SET operators are four types UNION, UNION ALL, INTERSECT, and MINUS ---------------------------------------------------------------------------------------------------- Assignment: Assignment link will be available soon ------------------------------------------------------------------------------------------------ In this series we cover the following topics: SQL basics, create table oracle, SQL functions, SQL queries, SQL server, SQL developer installation, Oracle database installation, SQL Statement, OCA, Data Types, Types of data types, SQL Logical Operator, SQL Function,Join- Inner Join, Outer join, right outer join, left outer join, full outer join, self-join, cross join, View, SubQuery, Set Operator. 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
Views: 33 EqualConnect Coach
Oracle SQL Developer Tutorial For Beginners  14   Basics of a SELECT statement
 
02:39
Oracle SQL Developer Tutorial For Beginners Series. This course introduces Oracle SQL Development for its subscribers. Currently this is based on Oracle 12c. The test environment is in Windows 10.
Views: 3424 Sam Dhanasekaran
Select Distinct Statement  | Part 5 | SQL tutorial for beginners | Tech Talk Tricks
 
03:16
Welcome to tech talk tricks and in this video, we will learn about the select distinct query.So stay tuned and watch the use of the distinct statement in SQL. #TechTalkTricks #RanaSingh In the current video, we will learn about how we can uniquely display or fetch data with the help of distinct SQL statement. The SELECT DISTINCT statement is used to return only distinct (different) values. Inside a table, a column often contains many duplicate values; and sometimes you only want to list the different (distinct) values. SELECT DISTINCT Syntax:SELECT DISTINCT column1, column2, ... FROM table_name; At tech talk trick channel you will learn all kind of technology like language,tutorials and amazing computer tips and tricks. sql distinct multiple columns sql distinct count select distinct on one column select distinct mysql sql distinct vs unique select distinct oracle select distinct on one column with multiple columns returned sql count distinct values ************************************************** Follow Tech Talk Trick on Facebook https://www.facebook.com/techtalktricks ************************************************** Follow tech talk trick on Twitter https://twitter.com/tecktalktrick ************************************************** Follow Tech Talk Tricks on Instagram https://www.instagram.com/techtalktricks ************************************************** Subscribe tech talk tricks on YouTube https://www.youtube.com/techtalktricks *************************************************** 1.How to make your computer start up & shutdown faster https://www.youtube.com/watch?v=3kSjizTn7MM 2.How To Trace Name/Address/Location Of UnKnown Number Easily https://www.youtube.com/watch?v=kyYfOP66l1Y 3.How to make webpage print friendly https://www.youtube.com/watch?v=YPR7JHA0Apk 4.How to Lock Folder Without any software https://www.youtube.com/watch?v=BhEduEM9pws 5.How to enable undo in Gmail https://www.youtube.com/watch?v=g1fOwTQ3zJg 6.How To Recover All Deleted, Formatted, Damaged Files https://www.youtube.com/watch?v=fl3DX6RBoqo 7.How to make Bootable USB Pendrive for Windows https://www.youtube.com/watch?v=IXJE859pxWg 8.How to Unlock Android Pattern or Pin Lock without losing data https://www.youtube.com/watch?v=yN4JnAo7SvU 9.how to track a cell phone location for free https://www.youtube.com/watch?v=0kCLyPJ8cM0 10.How to fix or repair pen drive using cmd https://www.youtube.com/watch?v=ny4VhM2TsWM 11.how to get wifi password of neighbor https://www.youtube.com/watch?v=LCFn6IjvnMM 12.How to Send an Email In Future https://www.youtube.com/watch?v=oo84GRHe5Vg 13.How To Setup Wifi Hotspot Without Any Software in Windows 10 https://www.youtube.com/watch?v=6Bzyvs44G50 14.how to download YouTube video without any software https://www.youtube.com/watch?v=RDfDGY3Be9Y 15.HOW TO SET SHUTDOWN TIMER IN WINDOWS OS (HINDI) https://www.youtube.com/watch?v=Vb5Ou7sc4uk 16.How To convert Word File (Any File Format) to PDF file (Any File Format) https://www.youtube.com/watch?v=Nd0YtV9MwqQ 17.How To Hide Drive of Computer Using Command Prompt (Hindi) https://www.youtube.com/watch?v=AddrPKRGdSk
Views: 1099 Tech Talk Tricks