Home
Search results “If in select sql oracle”
IF Statements in Oracle PL SQL with example
 
07:40
Complete Oracle PL/SQL Tutorial for Beginners Playlist here https://www.youtube.com/playlist?list=PLI5t0u6ye3FE_9SZcS0cQZDU2qn0uB1Oi ************************************************** This Video shows how to use IF THEN , ELSIF THEN and ELSE Statements in Oracle with examples for Beginners.
Views: 2418 yrrhelp
PL/SQL tutorial 9: IF THEN ELSE (IF-ELSE) Statement in PL/SQL by Manish Sharma
 
04:12
3rd tutorial in the series explaining IF-THEN-ELSE statement in Oracle PL/SQL with Example. Enjoy ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/if-then-else Previous Tutorial ► IF THEN Statement https://youtu.be/IWvuFD6eD30 ------------------------------------------------------------------------- ►►►Let's Get Free Uber Cab◄◄◄ Use Referral Code UberRebellionRider and get $20 free for your first ride. ------------------------------------------------------------------------- ►►►Help Me In Getting A Job◄◄◄ ►Help Me In Getting A Good Job By Connecting With Me on My LinkedIn and Endorsing My Skills. All My Contact Info is Down Below. You Can Also Refer Me To Your Company Thanks ------------------------------------------------------------------------- ►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: 66824 Manish Sharma
CASE STATEMENT(IF THEN ELSE) IN ORACLE SQL WITH EXAMPLE
 
06:28
The case statement gives the if-then-else kind of conditional ability to the otherwise static sql select statement, This video demonstrates how to write an case statement in oracle sql, and explains different aspects of the case statement. The video explains the execution flow of the case statement and advises on the best way to write one.
Views: 2525 Kishan Mashru
Oracle SQL TUTORIAL – IF condition using CASE and DECODE  - An Example
 
09:31
In this video, we shall see how case and decode is used in real time scenario. SQL used in the video is given below. SELECT * FROM emp_test ORDER BY gender; count_of_employees Count_of_Male_Employees Count OF Female Employees -- 15 5 8 select count(*) " Total Employees" from emp_test; select gender,count(*) " Total Employees" from emp_test group by gender; select sum(decode(gender,'M',1,0)) Count_OF_Male_Employees from emp_test; select sum(case gender when 'F' then 1 else 0 end) as Count_OF_FeMale_Employees from emp_test; SELECT count(*) " Total Employees" , sum(decode(gender,'M',1,0)) Count_OF_Male_Employees, sum(case gender when 'F' then 1 else 0 end) Count_OF_Female_Employees from emp_test;
Views: 124 Ganesh Anbarasu
CASE Function( IF..THEN..ELSE) in SQL ORACLE Query With Example
 
04:03
ORACLE/PLSQL: CASE STATEMENT The Oracle/PLSQL CASE statement has the functionality of an IF-THEN-ELSE statement. Starting in Oracle 9i, you can use the CASE statement within a SQL statement. The syntax for the Oracle/PLSQL CASE statement is: CASE [ expression ] WHEN condition_1 THEN result_1 WHEN condition_2 THEN result_2 ... WHEN condition_n THEN result_n ELSE result END --------- ARGUMENTS: expression is optional. It is the value that you are comparing to the list of conditions. (ie: condition_1, condition_2, ... condition_n) condition_1 to condition_n must all be the same datatype. Conditions are evaluated in the order listed. Once a condition is found to be true, the CASE statement will return the result and not evaluate the conditions any further. result_1 to result_n must all be the same datatype. This is the value returned once a condition is found to be true. NOTE: If no condition is found to be true, then the CASE statement will return the value in the ELSE clause. If the ELSE clause is omitted and no condition is found to be true, then the CASE statement will return NULL. You can have up to 255 comparisons in a CASE statement. Each WHEN ... THEN clause is considered 2 comparisons. Lets apply this function on emp table. Emp table has 3 dept numbers like 10,20 and 30. So if I want to display the different dept names based on ID, I have to use IF THEN ELSE condition. IF deptno=10 THEN "DEPT1" ELSE deptno=20 THEN "DEPT2" ELSE deptno=30 THEN "DEPT3" This entire IF block can be achived using CASE. CASE deptno WHEN 10 THEN 'DEPT1' WHEN 20 THEN 'DEPT2' WHEN 30 THEN 'DEPT3' ELSE 'NO DEPT' END; Query used in Video: select empno,ename,deptno,CASE deptno WHEN 10 THEN 'DEPT1' WHEN 20 THEN 'DEPT2' WHEN 30 THEN 'DEPT3' ELSE 'No Dept' END from emp;
Views: 16764 WingsOfTechnology
Oracle SQL Tutorial - If condition using Decode and Case Statements
 
08:56
In this tutorial, we will see how to use CASE and DECODE to construct an IF ELSE conditions in SQL. SQL used in this video are given below. Also, note as mentioned in video, the values we substitute for different data should be of same data type. select * from emp_test; Male Female better than just F IF gender = 'M' then print 'MALE', gender = 'F' then print 'Female', ELSE, print 'Unknown' select first_name,gender from emp_test; select first_name,DECODE(GENDER,'M','Male','F','Female','Unknown') Gender from emp_test; SELECT first_name,DECODE(GENDER,'M','Male','F','Female') Gender FROM emp_test; SELECT first_name, CASE GENDER WHEN 'M' THEN 'MALE' WHEN 'F' THEN 'FEMALE' END AS GENDER FROM EMP_TEST; SELECT first_name, CASE GENDER WHEN 'M' THEN 'MALE' WHEN 'F' THEN 'FEMALE' ELSE 'UNKNOWN' END AS GENDER FROM EMP_TEST; SB - Savings Bank CA - CURRENT ACCOUNT FD - Fixed Deposit LA - Loan ACCOUNT
Views: 65 Ganesh Anbarasu
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: 71883 SQL with Manoj
Oracle PL/SQL Tutorial -  If Statements
 
05:08
Want all of our free Oracle videos? Download our free iPad app at http://itunes.apple.com/us/app/video-training-courses-from/id418130423?mt=8 http://www.infiniteskills.com/training/learning-oracle-pl-sql-programming.html This PLSQL tutorial explains If-statements and their central role in development. YouTube: https://www.youtube.com/user/OreillyMedia Facebook: https://www.facebook.com/OReilly/?fref=ts Twitter: https://twitter.com/OReillyMedia Website: http://www.oreilly.com/
DECODE Function ( IF..THEN..ELSE) in SQL ORACLE Query With Example
 
05:35
ORACLE/PLSQL: DECODE FUNCTION The Oracle/PLSQL DECODE function has the functionality of an IF-THEN-ELSE statement. The syntax for the Oracle/PLSQL DECODE function is: DECODE( expression , search , result [, search , result]... [, default] ) ARGUMENTS: expression is the value to compare. search is the value that is compared against expression. result is the value returned, if expression is equal to search. default is optional. If no matches are found, the DECODE function will return default. If default is omitted, then the DECODE function will return null (if no matches are found). Lets apply this function on emp table. Emp table has 3 dept numbers like 10,20 and 30. So if I want to display the different dept names based on ID, I have to use IF THEN ELSE condition. IF deptno=10 THEN "DEPT1" ELSE deptno=20 THEN "DEPT2" ELSE deptno=30 THEN "DEPT3" This entire IF block can be achived using single DECODE(). DECODE(deptno,10,'DEPT1',20,'DEPT2',30,'DEPT3') Query used in Video: select empno,ename,deptno,DECODE(deptno,10,'DEPT1',20,'DEPT2',30,'DEPT3') from emp;
Views: 5649 WingsOfTechnology
Oracle Sql Step by Step Approach (071 if then else case statement)
 
03:20
Oracle Sql Step by Step Approach (071 if then else case statement) Discover essential SQL skills necessary to transform you into SQL developer which can earn you $70k+ in the IT Industry Learn to become a fee-earning SQL developer in just seven weeks. This fast, easy and effective course will take you from zero sql writing skills to being able to make money as a SQL developer. This one-stop-shot-style SQL course will teach you everything you need to know about SQL, from learning various database concepts to writing SQL to interact with the database. Throughout this SQL course I will be using the below methodology to make you think and help in forming the SQL statement. Like,Comment,Share
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: 369520 Chitu Okoli
Oracle SQL Developer: Query Builder Demo
 
08:13
How to build queries with your mouse versus the keyboard. 2018 Update: If you'd like to see how to convert your Oracle style JOINS to ANSI style (in the FROM vs the WHERE clause) see this post https://www.thatjeffsmith.com/archive/2018/10/query-builder-on-inline-views-and-ansi-joins/
Views: 78178 Jeff Smith
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: 181818 Joes2Pros SQL Trainings
PL/SQL tutorial 10: PL/SQL IF THEN ELSIF Statement in Oracle Database by Manish Sharma
 
04:55
Watch and learn IF THEN ELSIF (ELSIF ladder)statement in PL/SQL by Manish Sharma RebellionRider.com ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/if-then-elsif Previous Tutorial ► IF-ELSE https://youtu.be/IWsY_HzufKw ►Simple Case: https://youtu.be/DMlDwOmqAzo ►Searched Case: https://youtu.be/jk7k4TDs3F0 ►DECODE: https://youtu.be/lKXqXINCNLo ------------------------------------------------------------------------- ►►►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: 54777 Manish Sharma
Oracle PL/SQL - IF THEN ELSE Statement
 
04:57
http://plsqlzerotopro.com This tutorial explains IF THEN ELSE Statement.
Views: 10973 HandsonERP
66 - Oracle PL/SQL IF - Then - Else تعليم أوراكل
 
23:32
by Mohamed El Desouki - محمد الدسوقى [email protected] Tel :00966 553450836 جامعة سلمان بن عبد العزيز - السعودية - الخرج Database 2 - PL/SQL IF - Then - Else in Arabic Text Book: Fundamentals of Database Systems, 5th Edition, by Elmasri/Navathe, published by Addison-W
SQL Server Programming Part 5 - IF Statements
 
13:17
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can click this link https://www.wiseowl.co.uk/donate?t=1 to make a donation. Thanks for watching! By Andrew Gould https://www.wiseowl.co.uk - IF statements in SQL allow you to check if a condition has been met and, if so, to perform a sequence of actions. This video teaches you everything from the basic syntax of IF statements, including how to use the ELSE clause and perform multiple actions using a BEGIN and END block. We'll also teach you how to nest your IF statements, including a few useful tips on how to make your nested IFs readable! You can see more examples of IF in written form here: https://www.wiseowl.co.uk/blog/s340/if-else.htm You can download the script to create the Movies database used in this video at the following link: https://www.wiseowl.co.uk/files/execise-question-files/qf-898.zip You can see the range of resources and courses we offer in SQL Server here: https://www.wiseowl.co.uk/sql/ Visit www.wiseowl.co.uk for more online training resources in Microsoft Excel, Microsoft Access, Microsoft PowerPoint, Microsoft Word, Microsoft Project, Microsoft Publisher, Microsoft Visio, SQL Server, Reporting Services, Analysis Services, Visual Studio, ASP.NET, VB.NET, C# and more!
Views: 80690 WiseOwlTutorials
PL/SQL tutorial 8: Simple IF -THEN conditional Control Statement By Manish Sharma RebellionRider
 
04:43
Learn the concept of simple IF THEN conditional control statement in Oracle PL/SQL by Manish Sharma RebellionRider.com ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/simple-if-then-in-oracle Previous Tutorial ► https://youtu.be/aDBHco_VgMo ------------------------------------------------------------------------- ►►►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 Snapchat : RebellionRider 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 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: 68222 Manish Sharma
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: 10490 Mike Dane
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: 39139 Techtud
Lesson 9 - Query Filtering & Operator Precedence (Oracle SQL Certification)
 
19:55
Access all of my courses using the below discount: https://www.jobreadyprogrammer.com/p/all-access-pass/?product_id=1065350&coupon_code=60_PERCENT_DISCOUNT&preview=logged_out #Oracle #Java #Data analysis Get ready to acquire some seriously marketable programming skills! You can't consider yourself a complete end to end developer until you can code in SQL. Today, data has become the hottest topic in technology and a company's biggest asset is their data. All databases require the language SQL to store and retrieve data. Salaries for junior level SQL Developers are upwards of $70,000 - $90,000 dollars a year! The great thing is, for this course, you do not need any prior experience in programming what so ever. SQL is a different animal and we're going to demystify the language from scratch and prepare you with plenty of progressively challenging assignments so that by the time you've completed the course (in 2 months), you can call your self an Oracle SQL Master! Oracle is the most popular relational database in the world! This course will prepare you to be job-ready in just 1 month of study and practice. All exercises and solutions are in the lectures. In several lectures I ask students to pause the video and complete the assignment before resuming to watch my solution. MAKE SURE YOU WORK OUT THE PROBLEMS ON YOUR OWN BEFORE MOVING ON TO MY SOLUTION!! Who this course is for: Anyone willing to get into the software development career Anyone willing to Master SQL and get a job as a well paid Oracle SQL Developer Anyone willing to work hard in mastering the SQL language Anyone who is interested in passing the Oracle 1Z0-071 exam!
Views: 3857 Imtiaz Ahmad
Why Is My Query Slow? More Reasons Storing Dates as Numbers Is Bad
 
05:25
Storing dates as numbers can cause unexpected problems. In this video Chris looks at one possible issue: inconsistent query performance. He then shows methods you can use to improve performance, including function-based indexes and histograms. ============================ The Magic of SQL with Chris Saxon 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: 7574 The Magic of SQL
The SQL EXISTS clause
 
08:52
How to use the EXISTS clause in SQL. For beginners.
Views: 24682 Database by Doug
IF,While Loop in SQL Server
 
57:10
Website:https://www.eclasess.com loops in sql server If loop While Loop
70. IF ELSE construct in PL/SQL Oracle
 
05:19
In this video you will learn about IF ELSE construct 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: 5629 ITORIAN
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: 92894 kudvenkat
PL-SQL tutorial 25 - How to use Multiple IF-ELSIF-ELSE
 
05:46
Hi guys today i am going to explain about Selection Control Structure IF-ELSIF-ELSE in PL/SQL how to write a code in condition. Oracle database Unbeatable,Unbreakable Platform..
Views: 290 Oracle World
Select and Where: Databases for Developers #4
 
05:03
You query a database table with a select statement. But unless you provide a where clause, this will return you all the rows! That's a lot for you to sift through if your table has millions, billions or trillions of rows. In this episode Chris discusses common conditions for filtering rows so the database only returns what you need. Further reading: Oracle Database 12.2 select syntax: http://docs.oracle.com/database/122/SQLRF/SELECT.htm#SQLRF01702 Oracle Database Concepts Guide on Select: http://docs.oracle.com/database/122/CNCPT/sql.htm#GUID-702909E1-B214-4D30-A0F9-5A4335C2BA4A Take the Databases for Developers FREE SQL course at https://devgym.oracle.com/pls/apex/dg/class/databases-for-developers-foundations.html Daily SQL tips on Twitter: https://twitter.com/SQLDaily Chris on Twitter: https://twitter.com/ChrisRSaxon All Things SQL Blog: https://blogs.oracle.com/sql ============================ The Magic of SQL with Chris Saxon 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: 6528 The Magic of SQL
SQL Server If Else Statement Code Block
 
01:50
DECLARE @condition varchar(100) SET @condition = 'False' IF @condition = 'True' BEGIN Select 'IT IS TRUE!!!' END ELSE BEGIN Select 'IT IS FASLE!!' END
Views: 182 CKWTech LLC
Part 5   SQL query to find employees hired in last n months
 
04:53
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-5-sql-query-to-find-employees.html This question is asked is many sql server interviews. If you have used DATEDIFF() sql server function then you already know the answer. -- Replace N with number of months Select * FROM Employees Where DATEDIFF(MONTH, HireDate, GETDATE()) Between 1 and N
Views: 182847 kudvenkat
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: 254188 Joes2Pros SQL Trainings
Oracle PL/SQL - IF THEN ELSIF Statement
 
09:07
http://plsqlzerotopro.com This tutorial explains IF THEN ELSE IF statement.
Views: 6337 HandsonERP
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: 970249 kudvenkat
Tutorial#68 SubQuery in Oracle SQL Database by rakesh malviya
 
08:15
Explaining what is SubQuery in Oracle SQL and How SubQuery internally work in Oracle SQL database a subquery is a query within a query(Parent and Child Query). You can create subqueries within your SQL statements. These subqueries can reside in the WHERE, FROM and SELECT clause ------------------------------------------------------------------------------ Assignment Link: Assignment Link will come 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 Rakesh Malviya 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
Views: 72 EqualConnect Coach
How To Troubleshoot a Slow Running Query in SQL Server (Extended Events & Wait Stats) by Amit Bansal
 
17:48
In this video, you will understand how to track waits stats for a given query/session using Extended Events. Video resources including presentation, demo files, code snippets and more learning material is available on http://www.dataplatformgeeks.com/ (Join for free and access all the resources) Suggest us topics that you wish to learn through our videos: http://www.dataplatformgeeks.com/dpg-suggest-topics/ Connect With The Speaker (Amit Bansal) -Follow on Twitter: https://twitter.com/A_Bansal -Follow on FaceBook at http://www.facebook.com/amit.r.bansal -Follow on LinkedIN: http://www.linkedin.com/in/amitbansal2010 -Facebook Page: https://www.facebook.com/AmitRSBansal/ Connect with SQLMaestros: http://sqlmaestros.com/ -http://www.twitter.com/SQLMaestros -https://www.facebook.com/SQLMaestros -Email us: [email protected] Have technical questions? Join the largest SQL/Data group on FaceBook – https://www.facebook.com/groups/thesqlgeeks/ DataPlatformGeeks (DPG) Community Join the fastest growing community of data & analytics professionals Why Join DPG? http://www.dataplatformgeeks.com/ -Attend all events hosted by DPG, including SQLMaestros Special Events -Get access to free videos, labs, magazines and host of learning resources -Download all events & conference material -Learn new skills. Sharpen existing skills -Be part of Asia’s Largest Data/Analytics Community -Opportunity to be a regional mentor & speaker at our events -Immense technical & professional development -http://www.dataplatformgeeks.com/
Views: 53404 SQLMaestros
Introduction to Oracle: PL-SQL - IF ... ELSIF ... ELSE Statement
 
04:28
Introduction to Oracle: PL-SQL - IF ... ELSIF ... ELSE Statement
Views: 370 David Hays
PL/SQL Tutorial 6 : IF-THEN-ELSE Conditional Statement
 
09:52
Pl/SQL Tutorial 6 In these video the basic concept IF-THEN-ELSE statement of PL/SQL is explained Syntax:- IF condition THEN statements to be executed if condition is true; ELSE statements to be executed if condition is false; end if; The statements inside THEN and ELSE is executed if the condition is true. The statements inside ELSE and END IF is executed if the condition is false. We Hope You Understand these video Please Subscribe to our channel. Thank you for Watching.
SQL Server join :- Inner join,Left join,Right join and full outer join
 
08:11
For more such videos visit http://www.questpond.com For more such videos subscribe https://www.youtube.com/questpondvideos?sub_confirmation=1 Also watch Learn Sql Queries in 1 hour :- https://www.youtube.com/watch?v=uGlfP9o7kmY See our other Step by Step video series below :- Learn Data Science in 1 hour :- https://tinyurl.com/y5o7qbau Learn angular tutorial step by step https://tinyurl.com/ycd9j895 Learn C# Step by Step https://goo.gl/FNlqn3 Learn Design Pattern Step by Step https://goo.gl/eJdn0m Learn SQL Server Step by Step http://tinyurl.com/ja4zmwu Learn Data structures & algorithm https://tinyurl.com/ybx29c5s Learn MVC Core step by step :- http://tinyurl.com/y9jt3wkv Learn MSBI Step by Step in 32 hours:- https://goo.gl/TTpFZN Learn Xamarin Mobile Programming Step by Step :- https://goo.gl/WDVFuy Learn SharePoint Step by Step in 8 hours:- https://goo.gl/XQKHeP Learn Tableau step by step :- https://tinyurl.com/kh6ojyo Preparing for C# / .NET interviews start here http://www.youtube.com/watch?v=gaDn-sVLj8Q In this video we will try to understand four important concepts Inner joins,Left join,Right join and full outer joins. We are also distributing a 100 page Ebook ".Sql Server Interview Question and Answers". If you want this ebook please share this video in your facebook/twitter/linkedin account and email us on [email protected] with the shared link and we will email you the PDF.
Views: 893880 Questpond
How to Join 3 tables in 1 SQL query
 
04:59
Get your first month on the Joes 2 Pros Academy for just $1 with code YOUTUBE1. Visit http://www.joes2pros.com Offer expires July 1, 2015 From the newly released 2 Disc DVD set (SQL Queries Joes 2 Pros Vol2) this video shows how to join 3 tables in 1 query.
Views: 263127 Joes2Pros SQL Trainings
Install and configure Sql Developer on Windows | Oracle Tutorial
 
05:12
How to Install SQL Developer on Windows 1) Download for the below link http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html 2) Make sure you have Java Development Kit installed with latest version. http://www.oracle.com/technetwork/java/javase/downloads/index.html 3) Install SQL developer as rpm -ihv sqldeveloper-xxx.noarch.rpm (replace xxx with exact version of your SQL developer) Run SQL developer on linux command prompt as $ sqldeveloper 4) Create a new connection to connect to user Technology Lair : www.technologylair.org Subscribe : http://www.youtube.com/subscription_center?add_user=technologylair For More Videos : http://www.youtube.com/user/technologylair/videos For Video Tutorials :http://www.youtube.com/playlist?list=PLC71CFFF7A916DCAA For Android : http://www.youtube.com/playlist?list=PLUXK1VpPWQKHI1l-NvM5jvNKKnmNy9eHp For Linux : https://www.youtube.com/playlist?list=PLUXK1VpPWQKHV2xOmjQgUNj3Hrmcslj-H Kalam e Iqbal : http://www.youtube.com/playlist?list=PLF057785BD260F061 Like us on Facebook : https://www.facebook.com/technologylair Tweet us : http://twitter.com/technologylair Follow us : https://plus.google.com/u/0/118196883367288585963/posts Pin us : http://www.pinterest.com/technologylair/
Views: 346027 TechLair
Difference between where and having in sql server
 
06:36
sql server where vs having sql server group by where having group by having sql server In this vide we will discuss the difference between where and having caluses in sql server. Let us understand the difference with an example. To calculate total sales by product, we would write a GROUP BY query as shown below SELECT Product, SUM(SaleAmount) AS TotalSales FROM Sales GROUP BY Product Now if we want to find only those products where the total sales amount is greater than $1000, we will use HAVING clause to filter products SELECT Product, SUM(SaleAmount) AS TotalSales FROM Sales GROUP BY Product HAVING SUM(SaleAmount) ] 1000 If we use WHERE clause instead of HAVING clause, we will get a syntax error. This is because the WHERE clause doesn’t work with aggregate functions like sum, min, max, avg, etc. SELECT Product, SUM(SaleAmount) AS TotalSales FROM Sales GROUP BY Product WHERE SUM(SaleAmount) ] 1000 So in short, the difference is WHERE clause cannot be used with aggregates where as HAVING can. However, there are other differences as well that we need to keep in mind when using WHERE and HAVING clauses. WHERE clause filters rows before aggregate calculations are performed where as HAVING clause filters rows after aggregate calculations are performed. Let us understand this with an example. Total sales of iPhone and Speakers can be calculated by using either WHERE or HAVING clause Calculate Total sales of iPhone and Speakers using WHERE clause : In this example the WHERE clause retrieves only iPhone and Speaker products and then performs the sum. SELECT Product, SUM(SaleAmount) AS TotalSales FROM Sales WHERE Product in ('iPhone', 'Speakers') GROUP BY Product Calculate Total sales of iPhone and Speakers using HAVING clause : This example retrieves all rows from Sales table, performs the sum and then removes all products except iPhone and Speakers. SELECT Product, SUM(SaleAmount) AS TotalSales FROM Sales GROUP BY Product HAVING Product in ('iPhone', 'Speakers') So from a performance standpoint, HAVING is slower than WHERE and should be avoided when possible. Another difference is WHERE comes before GROUP BY and HAVING comes after GROUP BY. Difference between WHERE and Having 1. WHERE clause cannot be used with aggregates where as HAVING can. This means WHERE clause is used for filtering individual rows where as HAVING clause is used to filter groups. 2. WHERE comes before GROUP BY. This means WHERE clause filters rows before aggregate calculations are performed. HAVING comes after GROUP BY. This means HAVING clause filters rows after aggregate calculations are performed. So from a performance standpoint, HAVING is slower than WHERE and should be avoided when possible. 3. WHERE and HAVING can be used together in a SELECT query. In this case WHERE clause is applied first to filter individual rows. The rows are then grouped and aggregate calculations are performed, and then the HAVING clause filters the groups. Text version of the video http://csharp-video-tutorials.blogspot.com/2015/09/difference-between-where-and-having-in.html Slides http://csharp-video-tutorials.blogspot.com/2015/09/difference-between-where-and-having-in_15.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 Full SQL Server Course https://www.youtube.com/playlist?list=PL4cyC4G0M1RQ_Rm52cQ4CcOJ_T_HXeMB4 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: 72989 kudvenkat
Part 21 Learn If , Case, While in Sql Server in Hindi tutorial for beginners
 
06:21
The IF…ELSE statement imposes conditions on the execution of a Transact-SQL (T-SQL) statement. The T-SQL statement that follows an IF keyword is executed if its condition is satisfied. In that case the Boolean expression returns a TRUE value. When the IF condition is not satisfied and the Boolean expression returns FALSE, the optional ELSE keyword introduces another Transact-SQL statement and condition which is executed. This IF…ELSE statement is very similar to that of C Programming. he SQL Server (Transact-SQL) CASE statement has the functionality of an IF-THEN-ELSE statement. You can use the CASE statement within a SQL statement. Syntax The syntax for the CASE statement in SQL Server (Transact-SQL) is: CASE expression WHEN value_1 THEN result_1 WHEN value_2 THEN result_2 ... WHEN value_n THEN result_n ELSE result END
Views: 2636 Learn Everything
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: 285358 Manish Sharma
SQL Server interview questions :- What are Sub Query and Co-related Queries ?
 
09:39
For more such videos visit http://www.questpond.com For more such videos subscribe https://www.youtube.com/questpondvideos?sub_confirmation=1 See our other Step by Step video series below :- Learn Data Science in 1 hour :- https://tinyurl.com/y5o7qbau Learn angular tutorial step by step https://tinyurl.com/ycd9j895 Learn C# Step by Step https://goo.gl/FNlqn3 Learn Design Pattern Step by Step https://goo.gl/eJdn0m Learn Azure Step by Step :- https://tinyurl.com/y6fmrech Learn SQL Server Step by Step http://tinyurl.com/ja4zmwu Learn Data structures & algorithm https://tinyurl.com/ybx29c5s Learn MVC Core step by step :- http://tinyurl.com/y9jt3wkv Learn MSBI Step by Step in 32 hours:- https://goo.gl/TTpFZN Learn Xamarin Mobile Programming Step by Step :- https://goo.gl/WDVFuy Learn SharePoint Step by Step in 8 hours:- https://goo.gl/XQKHeP Learn Tableau step by step :- https://tinyurl.com/kh6ojyo Preparing for C# / .NET interviews start here http://www.youtube.com/watch?v=gaDn-sVLj8Q In this video we will try to understand what are SQL server sub queries , co-related queries and how they differ from each other. We are also distributing a 100 page Ebook "Sql Server Interview Question and Answers". If you want this ebook please share this video in your facebook/twitter/linkedin account and email us on [email protected] with the shared link and we will email you the PDF.
Views: 276304 Questpond
PL SQL Tutorials for Beginners | IF THEN ELSE Conditions
 
08:44
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. The IF-THEN-ELSIF statement allows you to choose between several alternatives. An IF-THEN statement can be followed by an optional ELSIF...ELSE statement. The ELSIF clause lets you add additional conditions. When using IF-THEN-ELSIF statements there are few points to keep in mind. It's ELSIF, not ELSEIF An IF-THEN statement can have zero or one ELSE's and it must come after any ELSIF's. An IF-THEN statement can have zero to many ELSIF's and they must come before the ELSE. Once an ELSIF succeeds, none of the remaining ELSIF's or ELSE's will be tested. Subscribe to our Channel for more videos https://www.youtube.com/channel/UC7sbHUgN8FnJEZkEjvKTwJg
Views: 135 Puzzle Guru

Fests in chicago this weekend
Cell phone hack free download
Bars in hamilton ohio
Jimmy gallu songs free download
Love more free download chris