Home
Search results “Years between oracle sql”
SQL Basics Part-7 Calculate the Difference between dates, Date Formats
 
13:31
An easy way to learn SQL in SQL Server Management Studio Environment
Views: 8875 SQL Learn & Share
Oracle SQL: Exploring Date Functions
 
07:29
http://www.informit.com/store/oracle-sql-livelessons-video-training-downloadable-9780134275741?WT.mc_id=Social_YT Oracle SQL: Exploring Date Functions is an excerpt from Oracle SQL LiveLessons Video Training -- 6+ Hours of Video -- Oracle SQL LiveLessons Video Training covers the basics of the Oracle SQL programming language. This course covers both Oracle standard SQL and the ANSI approved SQL that Oracle supports. The focus of the course is to give students working knowledge of the Oracle SQL language and at the conclusion of this course, students should be able to query the Oracle database. Description In this LiveLessons video course, Oracle ACE Director Dan Hotka will teach you how to use the SQL query language, interpret business questions into SQL code, and how to use Where clauses sub-queries, complex table join conditions, and how to create table objects and populate tables with data. Students will also learn how to access Oracle from Microsoft products such as Excel. In addition, they will learn how analytical SQL can be used for business analysis. This course will use both Toad and SQL Developer for SQL examples. About the Instructor Dan Hotka is a training specialist and an Oracle ACE director who has more than 37 years in the computer industry and more than 31 years of experience with Oracle products. His experience with the Oracle RDBMS dates back to the Oracle V4.0 days. Dan enjoys sharing his knowledge of the Oracle RDBMS. Dan is well published with 12 Oracle books and well over 200 published articles. He is also the video author for Oracle SQL Performance Tuning for Developers LiveLessons and Oracle PL/SQL Programming Fundamentals. He is frequently published in Oracle trade journals, regularly blogs, and speaks at Oracle conferences and user groups around the world. Visit his website at www.DanHotka.com. Skill Level Beginner Learn How To Use the SQL query language Interpret business questions into SQL code Understand Oracle standard SQL and ANSI SQL Work with Where clauses, sub-queries, and complex table join conditions Create table objects and populate these tables with data Access Oracle from Microsoft products such as Excel Use analytical SQL, useful for business analysts Who Should Take This Course Students who are new to SQL and want to learn Oracle SQL Course Requirements Basic knowledge of what is a database, especially RDBMS and what is a computer programming language http://www.informit.com/store/oracle-sql-livelessons-video-training-downloadable-9780134275741?WT.mc_id=Social_YT
Views: 4653 LiveLessons
SQL Tutorial - SQL DATE Functions like GETDATE, DATEADD, CONVERT
 
09:54
http://www.learningsqlserver2008.com/ https://youtu.be/KmsmPOImpHo - Date functions in SQL Server 2012 GETDATE -- Today's date DATEADD - adding time interval to an existing Date DATEPART - return part of the date like year or month DATEDIFF - Give you the different between two dates DAY - returns the day of the month MONTH - return the Month of the Year YEAR - returns the year in the Sql expression CAST - Converts an expression of one data type to another in SQL Server 2008 R2 CONVERT - Convert expressions of one data type to another in sql server r2 SQL Tutorial
Views: 55417 baghul
SQL DATEDIFF function - how to use SQL DATEDIFF function
 
01:38
The SQL Server DATEDIFF function returns the difference between two date values, based on the interval specified. visit Dose for excel Add-In website: http://www.zbrainsoft.com/ Visit our channel: https://www.youtube.com/channel/UCI4bMWYzrBTs47KINXL92Kw
Oracle PL/SQL Tutorials | Difference between Function and Procedure | Mr.Vaman Deshmukh
 
03:29
Oracle PL/SQL Tutorials | Difference between Function and Procedure | Mr.Vaman Deshmukh ** For Online Training Registration: https://goo.gl/r6kJbB ► Call: +91-8179191999 ► Visit Our Website for Classroom Training: https://nareshit.in ► For Online Training: https://nareshit.com/ -------------------------- ► About NareshIT: "Naresh IT is having 14+ years of experience in software training industry and the best Software Training Institute for online training, classroom training, weekend training, corporate training of Hadoop, Salesforce, AWS, DevOps, Spark, Data Science, Python, Tableau, RPA ,Java, C#.NET, ASP.NET, Oracle, Testing Tools, Silver light, Linq, SQL Server, Selenium, Android, iPhone, C Language, C++, PHP and Digital Marketing in USA,Hyderabad, Chennai and Vijayawada,Bangalore India which provides online training across all the locations -------------------------- ► Our Online Training Features: 1.Training with Real-Time Experts 2.Industry Specific Scenario’s 3.Flexible Timings 4.Soft Copy of Material 5. Share Videos of each and every session. -------------------------- Please write back to us at [email protected]/[email protected] or Call us at USA: +1404-232-9879 or India: +918179191999 ** Check The Below Links** ► For Course Reg: https://goo.gl/r6kJbB ► Subscribe to Our Channel: https://goo.gl/q9ozyG ► Circle us on G+: https://plus.google.com/NareshIT ► Like us on Facebook: https://www.facebook.com/NareshIT ► Follow us on Twitter: https://twitter.com/nareshitech ► Follow us on Linkedin: https://in.linkedin.com/company/naresh-i-technologies ► Follow us on Instagram: https://www.instagram.com/nareshitech/ #oraclepl/sqltutorialsvideos #programmingvideos
Oracle SQL: Understanding Multiple Table Joins
 
08:10
http://www.informit.com/store/oracle-sql-livelessons-video-training-downloadable-9780134275741?WT.mc_id=Social_YT Oracle SQL: Understanding Multiple Table Joins is an excerpt from Oracle SQL LiveLessons Video Training -- 6+ Hours of Video -- Oracle SQL LiveLessons Video Training covers the basics of the Oracle SQL programming language. This course covers both Oracle standard SQL and the ANSI approved SQL that Oracle supports. The focus of the course is to give students working knowledge of the Oracle SQL language and at the conclusion of this course, students should be able to query the Oracle database. Description In this LiveLessons video course, Oracle ACE Director Dan Hotka will teach you how to use the SQL query language, interpret business questions into SQL code, and how to use Where clauses sub-queries, complex table join conditions, and how to create table objects and populate tables with data. Students will also learn how to access Oracle from Microsoft products such as Excel. In addition, they will learn how analytical SQL can be used for business analysis. This course will use both Toad and SQL Developer for SQL examples. About the Instructor Dan Hotka is a training specialist and an Oracle ACE director who has more than 37 years in the computer industry and more than 31 years of experience with Oracle products. His experience with the Oracle RDBMS dates back to the Oracle V4.0 days. Dan enjoys sharing his knowledge of the Oracle RDBMS. Dan is well published with 12 Oracle books and well over 200 published articles. He is also the video author for Oracle SQL Performance Tuning for Developers LiveLessons and Oracle PL/SQL Programming Fundamentals. He is frequently published in Oracle trade journals, regularly blogs, and speaks at Oracle conferences and user groups around the world. Visit his website at www.DanHotka.com. Skill Level Beginner Learn How To Use the SQL query language Interpret business questions into SQL code Understand Oracle standard SQL and ANSI SQL Work with Where clauses, sub-queries, and complex table join conditions Create table objects and populate these tables with data Access Oracle from Microsoft products such as Excel Use analytical SQL, useful for business analysts Who Should Take This Course Students who are new to SQL and want to learn Oracle SQL Course Requirements Basic knowledge of what is a database, especially RDBMS and what is a computer programming language http://www.informit.com/store/oracle-sql-livelessons-video-training-downloadable-9780134275741?WT.mc_id=Social_YT
Views: 13403 LiveLessons
What is the difference between database refresh and database cloning
 
11:28
DBA Technologies. What is the difference between database refresh and cloning. http://oracledbatech.com
CTS interview questions on Oracle SQL and PLSQL
 
06:45
Here are the CTS interview questions on SQL and PLSQL. PL/SQL: What are the activities are you doing daily in your project? Tell me ratio's of sql, pl/sql & Unix? Diff b/w primary key & unique key + not null? What is the use of views? If table dropped, then what happen view? What is index? types of indexes? Which functions are not supported to index? What is save point? What is ora-1555? What are the data types available in pl/sql, not in sql? What is the main use of %type,%rowtype? What is cursor? Types of cursors? Diff b/w explicit cursor & for loop cursor? What is exception? Types of exceptions? What is raise_application_error? How many LONG columns are allowed in a table? What cursor type do you use to retrieve multiple record sets? What is normalization ? What is an index and types of indexes. How many number of indexes can be used per table ? how can we find the select statement is indexed or not? What are wait events. Describe the wait event tables. How do u count no of rows in a table? When do we create bitmap indexes sql query to get zero records from a table having n no of records function can return multiple value? how give give sample coding Difference between NVL, NVL2 and NULLIF Name Salary Abc 50000 Abc 50000 xyz 20000, find the max salary using aggregate function? What are the Diff B/W Cursor and REF Cursor What is pragma_exception_init? Diff b/w triggers & procedures? Can you call procedure in select statement? Restrictions in functions? What is the use of packages? How to drop package body only? Can use pragma_autonamous_tranctions in packages? What is bulk collect? What is nullif()? What is mutating error?  What are the module's , you are working Which will fire default first statement level or row level trigger? What is bulk collect? And any restrictions in bulk collect? What is the use of limit clause in bulk collect? How to debug your code? How to trace error handling? How to find which line error was raised? What are the methods there in save exceptions? What is functional based index? Write syntax? In my next video i will be providing you the answers for each on of this questions. For HCL interview question : https://youtu.be/Pf0lRerwF5U For Global Analytics interview questions : https://youtu.be/joRTF8ZhVwg Please subscribe to my channel here for more videos on recent interview questions of MNC companies. https://www.youtube.com/channel/UCofhGV_j_4cVGa9R08MsuXQ thanks to my subscribers !!
Views: 13090 Oracle PL/SQL
Oracle PL/SQL Tutorials | Diff. between Pre Defined Exception and User Defined Exception | Mr.Vaman
 
04:57
Oracle PL/SQL Tutorials | Difference. between Pre Defined Exception and User Defined Exception | Mr.Vaman ** For Online Training Registration: https://goo.gl/r6kJbB ► Call: +91-8179191999 ► Visit Our Website for Classroom Training: https://nareshit.in ► For Online Training: https://nareshit.com/ -------------------------- ► About NareshIT: "Naresh IT is having 14+ years of experience in software training industry and the best Software Training Institute for online training, classroom training, weekend training, corporate training of Hadoop, Salesforce, AWS, DevOps, Spark, Data Science, Python, Tableau, RPA ,Java, C#.NET, ASP.NET, Oracle, Testing Tools, Silver light, Linq, SQL Server, Selenium, Android, iPhone, C Language, C++, PHP and Digital Marketing in USA,Hyderabad, Chennai and Vijayawada,Bangalore India which provides online training across all the locations -------------------------- ► Our Online Training Features: 1.Training with Real-Time Experts 2.Industry Specific Scenario’s 3.Flexible Timings 4.Soft Copy of Material 5. Share Videos of each and every session. -------------------------- Please write back to us at [email protected]/[email protected] or Call us at USA: +1404-232-9879 or India: +918179191999 ** Check The Below Links** ► For Course Reg: https://goo.gl/r6kJbB ► Subscribe to Our Channel: https://goo.gl/q9ozyG ► Circle us on G+: https://plus.google.com/NareshIT ► Like us on Facebook: https://www.facebook.com/NareshIT ► Follow us on Twitter: https://twitter.com/nareshitech ► Follow us on Linkedin: https://in.linkedin.com/company/naresh-i-technologies ► Follow us on Instagram: https://www.instagram.com/nareshitech/ ---------------------------------------------------------------------------------------------------- #oracletraining #oraclevideos #oracletutorials #sqltrainingvideos #sqltutorials
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: 161906 kudvenkat
Year-to-Date using Partition By with Windowing - SQL Training Online
 
05:43
You can use the Partition By Function in SQL Server to get a Year-to-Date and Month-to_Date calculation. In this video I show you how to create a Year-to-Date value using the Windowing Partition By Function in TSQL. READ THE ORIGINAL ARTICLE WITH SQL SCRIPTS HERE http://www.sqltrainingonline.com/year-to-date-using-the-partition-by-function-with-windowing-in-sql-server/ 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! Google+: http://gplus.to/SQLTrainingOnline Facebook: http://facebook.com/SQLTrainingOnline Twitter: http://twitter.com/sql_by_joey Linkedin: http://linkedin.com/in/joeyblue SQLTrainingOnline: http://www.sqltrainingonline.com
Views: 1850 Joey Blue
get all date between two dates in sql server
 
04:05
Query for get the date between two date in SQL Server, Here i am using the CTE (Common tabular expression) , CTE Is very useful for recurssion
Views: 4293 Code Topic
HCL Interview Questions on PL\SQL
 
48:11
My Experience in HCL Interview on PL/SQL . Here I shared My Interview Questions With YOU..... I hope it may use for Job Seekers Who are searching on PL/SQL.
Views: 16908 Useful Tips
SQL Date Comparison - How to filter Datetime in SQL Server - SQL Training Online
 
08:41
http://www.sqltrainingonline.com SQL Date Comparison - How to filter Datetime in SQL Server - SQL Training Online In this video, I show you how to do a SQL Date Comparison in SQL Server when your Datetime has an actual time in it. I also include the latest trick that will make this easier if you are using SQL Server 2008 or SQL Server 2012. How do you compare a Datetime in SQL Server? A SQL Datetime stores both Date and Time. So when you are filtering using the SQL Where clause, you have to know if you Datetime is storing the time also. Let's take a look at the employee table in SQL Training Online Simple DB The column we are looking at is the hire date. I want to go after the person who was hired on February, 22 2005. So, I use the following SQL. select * from employee where hire_date='02/22/2005' Now, this works because we don't have any times stored in this column. But, if I change the record from 2005-02-22 00:00:00.000 to 2005-02-22 08:22:25.000 and rerun the query, you see that I don't get any results. That is because the value of 02/22/2005 is really 2005-02-22 00:00:00.000 and I just changed the hire_date to include a time other than 00:00:00.000. So, I have to tweak my query to use a greater than and less than sign. This works. But, to really understand what is going on, let me show you what SQL Server really sees. There are other ways, and in this StackOverflow article you can read more about these other ways. But, I want to point out a few. If you are working in SQL Server 2005 or earlier, the following is supposed to be the fastest performing way to do this. select datediff(dd,0, hire_date),* from employee where dateadd(dd,0, datediff(dd,0, hire_date)) = '2005-02-22' But, if you are working in SQL Server 2008 or SQL Server 2012, they have introduced an actual Date datatype that doesn't include the Time portion. Since this is the case, you can use the CAST function to remove the time from the Datetime. Here is the SQL to do that. select * from employee where CAST(hire_date AS Date) = '2005-02-22' And that's it. If you enjoy the video, please give it a like, comment, or subscribe to my channel. You can visit me at any of the following: SQL Training Online: http://www.sqltrainingonline.com Twitter: http://www.twitter.com/sql_by_joey Google+: https://plus.google.com/#100925239624117719658/posts LinkedIn: http://www.linkedin.com/in/joeyblue Facebook: http://www.facebook.com/sqltrainingonline
Views: 26470 Joey Blue
Top 50 Oracle pl sql interview questions with answers and basic level of plsql
 
25:33
Oracle PL/SQL in 20 min. Here i have covered he basic concepts and basic level of interview questions of Oracle PL/SQL. ------------------------------------------------------------------------ Blog : http://techroundinterviewque.blogspot.in/ FB: https://www.facebook.com/jobupdates.necg/ Google+: https://plus.google.com/u/0/105097188725173992509 twitter: https://twitter.com/Oracle_pl_sql -------------------------------------------------------------------------- Make sure you SUBSCRIBE and be the 1st one to see my videos! -------------------------------------------------------------------------- In my next video i will be providing you the answers for each on of this questions. For HCL interview question : https://youtu.be/Pf0lRerwF5U For Global Analytics interview questions : https://youtu.be/joRTF8ZhVwg For CTS interview questions: https://www.youtube.com/watch?v=ISpHa... For accenture interview questions: https://www.youtube.com/watch?v=lojdZA7pT4o For 3i infotech interview questions: https://www.youtube.com/watch?v=aI7_45hSb5o For Infosys interview questions: https://www.youtube.com/watch?v=l4hfRvcnyxk For top 30 PLSQL interview questions: https://www.youtube.com/watch?v=pNiVsMHTk68 Please subscribe to my channel here for more videos on recent interview questions of MNC companies. https://www.youtube.com/channel/UCofh... Please please LIKE and SHARE my videos it makes me happy. Thanks for liking, commenting, sharing and watching more of our videos This is Oracle PLSQL group from http://techroundinterviewque.blogspot.in/ https://www.youtube.com/channel/UCofh... I LOVE ALL MY VIEWERS AND SUBSCRIBERS thanks to my subscribers !!
Views: 29446 Oracle PL/SQL
PL/SQL interview questions and answers
 
08:22
PL/SQL interview questions and answers - most frequently asked PL/SQL interview questions and answers
Views: 135499 CareerRide
Oracle PL/SQL Tutorials | Difference between NESTED TABLE and VARRAY  | by Mr.Vaman Deshmukh
 
03:50
Oracle PL/SQL Tutorials | Difference Between VARRAY, NESTED TABLE, PL: SQL TABLE | by Mr.Vaman Deshmukh Oracle Nested Tables and Varrays Oracle Varray and Nested table performance ** For Online Training Registration: https://goo.gl/r6kJbB ► Call: +91-8179191999 ► Visit Our Website for Classroom Training: https://nareshit.in ► For Online Training: https://nareshit.com/ -------------------------- ► About NareshIT: "Naresh IT is having 14+ years of experience in software training industry and the best Software Training Institute for online training, classroom training, weekend training, corporate training of Hadoop, Salesforce, AWS, DevOps, Spark, Data Science, Python, Tableau, RPA ,Java, C#.NET, ASP.NET, Oracle, Testing Tools, Silver light, Linq, SQL Server, Selenium, Android, iPhone, C Language, C++, PHP and Digital Marketing in USA,Hyderabad, Chennai and Vijayawada,Bangalore India which provides online training across all the locations -------------------------- ► Our Online Training Features: 1.Training with Real-Time Experts 2.Industry Specific Scenario’s 3.Flexible Timings 4.Soft Copy of Material 5. Share Videos of each and every session. -------------------------- Please write back to us at [email protected]/[email protected] or Call us at USA: +1404-232-9879 or India: +918179191999 ** Check The Below Links** ► For Course Reg: https://goo.gl/r6kJbB ► Subscribe to Our Channel: https://goo.gl/q9ozyG ► Circle us on G+: https://plus.google.com/NareshIT ► Like us on Facebook: https://www.facebook.com/NareshIT ► Follow us on Twitter: https://twitter.com/nareshitech ► Follow us on Linkedin: https://in.linkedin.com/company/naresh-i-technologies ► Follow us on Instagram: https://www.instagram.com/nareshitech/
Oracle PL/SQL select into clause  | Oracle SQL Tutorial | Mr.Murali
 
16:40
Oracle PL/SQL select into clause l | Oracle SQL Tutorial | Mr.Murali ** For Online Training Registration: https://goo.gl/r6kJbB ► Call: +91-8179191999 ► Visit Our Website for Classroom Training: https://nareshit.in ► For Online Training: https://nareshit.com/ #Oracle #SQL #Tutorials -------------------------- ► About NareshIT: "Naresh IT is having 14+ years of experience in software training industry and the best Software Training Institute for online training, classroom training, weekend training, corporate training of Hadoop, Salesforce, AWS, DevOps, Spark, Data Science, Python, Tableau, RPA ,Java, C#.NET, ASP.NET, Oracle, Testing Tools, Silver light, Linq, SQL Server, Selenium, Android, iPhone, C Language, C++, PHP and Digital Marketing in USA,Hyderabad, Chennai and Vijayawada,Bangalore India which provides online training across all the locations -------------------------- ► Our Online Training Features: 1.Training with Real-Time Experts 2.Industry Specific Scenario’s 3.Flexible Timings 4.Soft Copy of Material 5. Share Videos of each and every session. -------------------------- Please write back to us at [email protected]/[email protected] or Call us at USA: +1404-232-9879 or India: +918179191999 ** Check The Below Links** ► For Course Reg: https://goo.gl/r6kJbB ► Subscribe to Our Channel: https://goo.gl/q9ozyG ► Circle us on G+: https://plus.google.com/NareshIT ► Like us on Facebook: https://www.facebook.com/NareshIT ► Follow us on Twitter: https://twitter.com/nareshitech ► Follow us on Linkedin: https://in.linkedin.com/company/naresh-i-technologies ► Follow us on Instagram: https://www.instagram.com/nareshitech/
Oracle PL/SQL Tutorials | Difference between DROP, TRUNCATE and DELETE | by Mr.Vaman Deshmukh
 
06:01
Oracle PL/SQL Tutorials | Difference between DROP, TRUNCATE and DELETE | by Mr.Vaman Deshmukh Difference between TRUNCATE , DELETE and DROP in SQL Server Difference between delete truncate and drop in sql ** For Online Training Registration: https://goo.gl/r6kJbB ► Call: +91-8179191999 ► Visit Our Website for Classroom Training: https://nareshit.in ► For Online Training: https://nareshit.com/ #OraclePLSQLTutorials #DifferencebetweenDROPTRUNCATEandDELETE #Tutorials -------------------------- ► About NareshIT: "Naresh IT is having 14+ years of experience in software training industry and the best Software Training Institute for online training, classroom training, weekend training, corporate training of Hadoop, Salesforce, AWS, DevOps, Spark, Data Science, Python, Tableau, RPA ,Java, C#.NET, ASP.NET, Oracle, Testing Tools, Silver light, Linq, SQL Server, Selenium, Android, iPhone, C Language, C++, PHP and Digital Marketing in USA,Hyderabad, Chennai and Vijayawada,Bangalore India which provides online training across all the locations -------------------------- ► Our Online Training Features: 1.Training with Real-Time Experts 2.Industry Specific Scenario’s 3.Flexible Timings 4.Soft Copy of Material 5. Share Videos of each and every session. -------------------------- Please write back to us at [email protected]/[email protected] or Call us at USA: +1404-232-9879 or India: +918179191999 ** Check The Below Links** ► For Course Reg: https://goo.gl/r6kJbB ► Subscribe to Our Channel: https://goo.gl/q9ozyG ► Circle us on G+: https://plus.google.com/NareshIT ► Like us on Facebook: https://www.facebook.com/NareshIT ► Follow us on Twitter: https://twitter.com/nareshitech ► Follow us on Linkedin: https://in.linkedin.com/company/naresh-i-technologies ► Follow us on Instagram: https://www.instagram.com/nareshitech/
Union and union all in sql server   Part 17
 
12:41
In this video we will learn about the 1. Purpose of UNION and UNION ALL 2. Difference between UNION and UNION ALL 3. Difference between JOIN and UNION Text version of the video http://csharp-video-tutorials.blogspot.com/2012/08/union-and-union-all-in-sql-server-part.html Slides http://csharp-video-tutorials.blogspot.com/2013/08/part-17-union-and-union-all.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: 246945 kudvenkat
Top 10 PL/SQL Interview Questions
 
04:04
http://career.guru99.com/top-50-plsql-interview-questions/ Questions covered in this video are 1) What is PL SQL ? 2) Differentiate between % ROWTYPE and TYPE RECORD. 3) Explain Commit, Rollback and Savepoint. 4) Explain polymorphism in PL/SQL. 5) What are the cursor attributes of PL/SQL. 6) How functions and procedures are called in a PL/SQL block. 7) Show code of a cursor for loop. 8) Explain the uses of database trigger. 9) How is a process of PL/SQL compiled? 10) Define Implicit and Explicit Cursors.
Views: 54408 Guru99
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: 33756 Techtud
How to calculate date,year,moth,week from date in sql server  -Sql Server
 
02:11
How to calculate date,year,moth,week from date -Sql Server
Views: 2154 GoPro
Function: Is Leap Year - SQL in Sixty Seconds #004
 
01:12
A function build from 4 other function which validates if any year leap year or not. Read More Here: http://wp.me/p2NUQ-4Ae
Views: 3603 Pinal Dave
TCS SQL Interview Questions
 
12:36
Video talks about Top SQL Interview Questions Top SQL Interview Questions and answers sql faq sql interview questions qith answers Top 10 Frequently Asked Interview Questions in SQL Top 10 SQL Interview Questions and Answers Video talks about SQL Procedure Interview Questions SQL Interview Questions SQL Interview Questions and answers Top SQL Interview Questions SQL Interview call SQL FAQ's top sql faq sql training videos sql stored procedure stored procedure in sql server advantages of using stored procedure sql procedure questions differences between Stored Procedure and Functions in SQL What are stored procedures-Advantages of Stored procedures in sql sql tutorial SQL Server Interview Questions and Answers: For All Database Developers and Developers Administrators Step by step SQL Training videos SQL Tutorial
Views: 79909 Training2SQL MSBI
Difference Between Admin Login and User Login | MSSQL Training
 
32:01
** For Online Training Registration: https://goo.gl/r6kJbB ? Call: +91-8179191999 ? Visit Our Website for Classroom Training: https://nareshit.in/sql-server-training/ ? For Online Training: https://nareshit.com/course/sql-server-online-training/ #sqlserver #server #programming #course #Tutorials #Training #Videos -------------------------- ? About NareshIT: "Naresh IT is having 14+ years of experience in software training industry and the best Software Training Institute for online training, classroom training, weekend training, corporate training of Hadoop, Salesforce, AWS, DevOps, Spark, Data Science, Python, Tableau, RPA ,Java, C#.NET, ASP.NET, Oracle, Testing Tools, Silver light, Linq, SQL Server, Selenium, Android, iPhone, C Language, C++, PHP and Digital Marketing in USA,Hyderabad, Chennai and Vijayawada,Bangalore India which provides online training across all the locations -------------------------- ? Our Online Training Features: 1.Training with Real-Time Experts 2.Industry Specific Scenario’s 3.Flexible Timings 4.Soft Copy of Material 5. Share Videos of each and every session. -------------------------- Please write back to us at [email protected]/[email protected] or Call us at USA: +1404-232-9879 or India: +918179191999 ** Check The Below Links** ? For Course Reg: https://goo.gl/r6kJbB ? Subscribe to Our Channel: https://goo.gl/q9ozyG ? Circle us on G+: https://plus.google.com/NareshIT ? Like us on Facebook: https://www.facebook.com/NareshIT ? Follow us on Twitter: https://twitter.com/nareshitech ? Follow us on Linkedin: https://in.linkedin.com/company/naresh-i-technologies ? Follow us on Instagram: https://www.instagram.com/nareshitech/
Views: 28472 Naresh i Technologies
Using DATEADD to Add and Subtract Days from a Date in SQL (C1B1T1 7.3)
 
03:52
Using DATEADD to Add and Subtract Days from a Date in SQL (C1B1T1 7.3)
Views: 1747 Ian Martyn
SQL: Delete Vs Truncate Vs Drop
 
08:27
In this tutorial, you'll learn the difference between delete/drop and truncate. PL/SQL (Procedural Language/Structured Query Language) is Oracle Corporation's procedural extension for SQL and the Oracle relational database. PL/SQL is available in Oracle Database (since version 7), TimesTen in-memory database (since version 11.2.1), and IBM DB2 (since version 9.7).[1] Oracle Corporation usually extends PL/SQL functionality with each successive release of the Oracle Database. PL/SQL includes procedural language elements such as conditions and loops. It allows declaration of constants and variables, procedures and functions, types and variables of those types, and triggers. It can handle exceptions (runtime errors). Arrays are supported involving the use of PL/SQL collections. Implementations from version 8 of Oracle Database onwards have included features associated with object-orientation. One can create PL/SQL units such as procedures, functions, packages, types, and triggers, which are stored in the database for reuse by applications that use any of the Oracle Database programmatic interfaces. PL/SQL works analogously to the embedded procedural languages associated with other relational databases. For example, Sybase ASE and Microsoft SQL Server have Transact-SQL, PostgreSQL has PL/pgSQL (which emulates PL/SQL to an extent), and IBM DB2 includes SQL Procedural Language,[2] which conforms to the ISO SQL’s SQL/PSM standard. The designers of PL/SQL modeled its syntax on that of Ada. Both Ada and PL/SQL have Pascal as a common ancestor, and so PL/SQL also resembles Pascal in several aspects. However, the structure of a PL/SQL package does not resemble the basic Object Pascal program structure as implemented by a Borland Delphi or Free Pascal unit. Programmers can define public and private global data-types, constants and static variables in a PL/SQL package.[3] PL/SQL also allows for the definition of classes and instantiating these as objects in PL/SQL code. This resembles usage in object-oriented programming languages like Object Pascal, C++ and Java. PL/SQL refers to a class as an "Abstract Data Type" (ADT) or "User Defined Type" (UDT), and defines it as an Oracle SQL data-type as opposed to a PL/SQL user-defined type, allowing its use in both the Oracle SQL Engine and the Oracle PL/SQL engine. The constructor and methods of an Abstract Data Type are written in PL/SQL. The resulting Abstract Data Type can operate as an object class in PL/SQL. Such objects can also persist as column values in Oracle database tables. PL/SQL is fundamentally distinct from Transact-SQL, despite superficial similarities. Porting code from one to the other usually involves non-trivial work, not only due to the differences in the feature sets of the two languages,[4] but also due to the very significant differences in the way Oracle and SQL Server deal with concurrency and locking. There are software tools available that claim to facilitate porting including Oracle Translation Scratch Editor,[5] CEITON MSSQL/Oracle Compiler [6] and SwisSQL.[7] The StepSqlite product is a PL/SQL compiler for the popular small database SQLite. PL/SQL Program Unit A PL/SQL program unit is one of the following: PL/SQL anonymous block, procedure, function, package specification, package body, trigger, type specification, type body, library. Program units are the PL/SQL source code that is compiled, developed and ultimately executed on the database. The basic unit of a PL/SQL source program is the block, which groups together related declarations and statements. A PL/SQL block is defined by the keywords DECLARE, BEGIN, EXCEPTION, and END. These keywords divide the block into a declarative part, an executable part, and an exception-handling part. The declaration section is optional and may be used to define and initialize constants and variables. If a variable is not initialized then it defaults to NULL value. The optional exception-handling part is used to handle run time errors. Only the executable part is required. A block can have a label. Package Packages are groups of conceptually linked functions, procedures, variables, PL/SQL table and record TYPE statements, constants, cursors etc. The use of packages promotes re-use of code. Packages are composed of the package specification and an optional package body. The specification is the interface to the application; it declares the types, variables, constants, exceptions, cursors, and subprograms available. The body fully defines cursors and subprograms, and so implements the specification. Two advantages of packages are: Modular approach, encapsulation/hiding of business logic, security, performance improvement, re-usability. They support object-oriented programming features like function overloading and encapsulation. Using package variables one can declare session level (scoped) variables, since variables declared in the package specification have a session scope.
Views: 59367 radhikaravikumar
Oracle Data integrator Interview Questions & Answers
 
41:25
Oracle Data integrator Interview Questions & Answers Difference between ODI 11g and 12C ODI 12c New Features.
Views: 3985 TechLake
ORACLE DBA Telephonic Round Interview
 
42:01
-uploaded in HD at http://www.TunesToTube.com
Views: 124821 Yasin Basha
PLS-11: Oracle PL/SQL Reference Cursor
 
08:43
Oracle For Full Course Experience Please Go To http://mentorsnet.org/course_preview?course_id=5 Full Course Experience Includes 1. Access to course videos and exercises 2. View & manage your progress/pace 3. In-class projects and code reviews 4. Personal guidance from your Mentors
Views: 72815 Oresoft LWC
DateTime functions in SQL Server   Part 25
 
15:26
In this video we will learn about different DateTime data types, and different date time functions in sql server. We will also understand the difference between terms UTC (Coordinated Universal Time) and Time Zone offset. Text version of the video http://csharp-video-tutorials.blogspot.co.uk/2012/09/datetime-functions-in-sql-server-part-25.html Slides http://csharp-video-tutorials.blogspot.com/2013/08/part-25-datetime-functions-in-sql-server.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: 193290 kudvenkat
What is the Difference between Primary Key and Unique Key - Database Tutorial 14
 
04:51
Database Tutorial. This video is about Database Fundamentals. I hope this series of videos can help those who want to be Database Professionals. I will cover various database technologies including Oracle Database, Microsoft SQL Server database and Sybase. Video: What is the Difference between Primary Key and Unique Key (Video 14 in the Database Tutorial Series) (Common for Oracle/Microsft SQL Server/Sybase /MySQL)
Views: 33212 Sam Dhanasekaran
Clauses in SQL Server | MSSQL Training Tutorial
 
25:39
** For Online Training Registration: https://goo.gl/r6kJbB ? Call: +91-8179191999 ? Visit Our Website for Classroom Training: https://nareshit.in/sql-server-training/ ? For Online Training: https://nareshit.com/course/sql-server-online-training/ #sqlserver #server #programming #course #Tutorials #Training #Videos -------------------------- ? About NareshIT: "Naresh IT is having 14+ years of experience in software training industry and the best Software Training Institute for online training, classroom training, weekend training, corporate training of Hadoop, Salesforce, AWS, DevOps, Spark, Data Science, Python, Tableau, RPA ,Java, C#.NET, ASP.NET, Oracle, Testing Tools, Silver light, Linq, SQL Server, Selenium, Android, iPhone, C Language, C++, PHP and Digital Marketing in USA,Hyderabad, Chennai and Vijayawada,Bangalore India which provides online training across all the locations -------------------------- ? Our Online Training Features: 1.Training with Real-Time Experts 2.Industry Specific Scenario’s 3.Flexible Timings 4.Soft Copy of Material 5. Share Videos of each and every session. -------------------------- Please write back to us at [email protected]/[email protected] or Call us at USA: +1404-232-9879 or India: +918179191999 ** Check The Below Links** ? For Course Reg: https://goo.gl/r6kJbB ? Subscribe to Our Channel: https://goo.gl/q9ozyG ? Circle us on G+: https://plus.google.com/NareshIT ? Like us on Facebook: https://www.facebook.com/NareshIT ? Follow us on Twitter: https://twitter.com/nareshitech ? Follow us on Linkedin: https://in.linkedin.com/company/naresh-i-technologies ? Follow us on Instagram: https://www.instagram.com/nareshitech/
Views: 17643 Naresh i Technologies
SDU Tools 62 Date Difference Excluding Weekends in SQL Server T-SQL
 
01:27
SDU Tools are free tools for SQL Server developers and DBAs. This tool is a T-SQL function that calculates the number of days between two dates, excluding weekends (ie: Monday to Friday only). You'll find more info about SDU Tools and download details at http://www.sqldownunder.com/Resources/SDUTools
Views: 221 SQL Down Under
Oracle SQL Developer: Tips and Tricks
 
01:13:14
Aiodex’s Referral Program  will give you 20% -80% commission from their transaction fee for 7 years. The value will be calculated starting from the date the member you invite sign up. ☞ https://aiodex.com/?ref=5b45a599c7165734d36bb3fc CodeGeek's Discuss ☞ https://discord.gg/KAe3AnN Playlists Video Tutorial ☞ http://bit.ly/2IQdTwR Learn to Code and Everything for Startup ☞ https://codequs.com Get Free 15 Geek ☞ https://my.geekcash.io/ref/5b3c4924d38b6158ce04633f or http://geekcash.org/ Oracle SQL : Become a Certified SQL Developer From Scratch! ☞ http://learnstartup.net/p/rkbnlLjsb Oracle SQL 11g + Oracle Apps R12 DBA ☞ http://learnstartup.net/p/SkcD6DbZx Oracle SQL - Step by Step SQL ☞ http://learnstartup.net/p/BJbrxLjsb Oracle - The Complete SQL Guide (includes SQL Certification) ☞ http://learnstartup.net/p/B1vRyIii- SQL For Beginners ☞ http://learnstartup.net/p/H1T9sf6KZ SQL From Scratch Using Oracle SQL Developer and TOAD ☞ http://learnstartup.net/p/BksS-_Wbl Oracle SQL Developer is currently the most popular tool among database developers and Oracle SQL learners, however, since it makes it so easy to start firing commands and querying a database, many people don't feel the need to investigate its features, and end up using only what is obvious, visible, and enabled by default. If you are one of them, this course will help you get out of that group and start using Oracle SQL Developer more smartly. Even if you have some time using the tool and are currently using some of its features, there's most likely something in this course that you don't know and can be helpful to you. Learn the features that can help you work with your Oracle database better and faster: Install and configure Oracle SQL Developer to run in your desired language and only with the features you need. Create database connections and execute commands and scripts. Display your results in a way that makes your work easier. Use code templates and snippets to accelerate your work. Export data in different formats and using different methods. Some other useful and interesting things. All Oracle SQL Developer features are free. Take advantage of them: This course was created because there appears to be a pattern among Oracle SQL courses, regardless of the platform where they are taught: “If you are able to install it and connect to a database, you are good to go". What's more: Experience shows that even developers who are already working with Oracle databases as part of their job, tend to not look for ways to work faster in SQL Developer, and usually only investigate features they don't currently use when it is strictly necessary for their jobs. The goal of this course is to fill the gap most SQL courses leave about this great tool so that it can serve as a foundation if you are planning to learn Oracle SQL, and also to help you take advantage of the tool's features if you are already working with Oracle databases as part of your job. Content and Overview: The course includes more than 20 lectures, each one starting by showing you why you need it or how it can be helpful to you, and then proceeding to demonstrate how to enable it and/or use it. There is usually one lecture per feature, so, if for any reason you are not interested in any of the included tips, you can simply skip it, and go directly to the one you want to learn about. The course content will continue to be updated over time, to make sure you always know about the most important features available to you, as new versions of Oracle SQL Developer are released. Learn these tips and apply them to your work, and you will not only be well prepared to learn SQL or work with it smartly, but will also enjoy being seen as an experienced and knowledgeable developer by your friends and peers. Video source via: ---------------------------------------------------- Website: http://bit.ly/2pN2aXx Playlist: http://bit.ly/2Eyn3dI Website: http://bit.ly/2Hay229 Fanpage: http://bit.ly/2GQvOBx Twitter: http://bit.ly/2GOyTlA Pinterest: http://bit.ly/2qihWtz Tumblr: http://bit.ly/2qjBcGo
Views: 43 Database Tutorials
2 - 3 Years Sankhya InfoTech Job Openings Oracle PL/SQL Developer LastaDate 22nd May 2015 Hyderabad
 
01:11
2 - 3 Years Sankhya InfoTech Job Openings Oracle PL/SQL Developer LastaDate 22nd May 2015 Hyderabad 2011 FRESHER JOBS Company Sankhya InfoTech Website www.sankhya.net Eligibility BE/B.Tech /MCA Experience 2 - 3 yrs Location ECIL, Hyderabad Job Role Oracle PL/SQL Developer Job Description: Oracle Database Developer, should be proficient in SQL and PL/SQL, should have basic database administration, working knowledge of data porting using sql loader and oracle stored procedure. Job Role: Have to work at client location and need to support an e-Learning database. 1. Proficient in SQL and PL/SQL as reports are to be generated on daily basis as per the clients Requirement. 2. Working knowledge of data porting using SQL Loader and Oracle stored procedures. 3. Basic Database administration 4. Good communication skills, and should have problem solving skills. 5. Interacting with clients for technical / functional inputs and implementation. Candidate Profile: Skills Required: 1. Oracle PL/SQL Developer Certified Associate (or) Oracle Advanced PL/SQL Developer Certified Professional 2. Windows and Linux Operating System 3. Oracle Database Development 4. E-Leaning Domain (added advantage) 5. Open Source LMS like Moodle & Sakai (added advantage) Qualification: BE/B.Tech or MCA Contact Person : HR Contact Details : [email protected] , 040 3024 6300 For more infomation : Website : http://www.recruitment180.com/ Facebook Group : https://www.facebook.com/groups/recruitment180/ Facebook Page : https://www.facebook.com/recruitment180/ Twitter : Facebook Page : https://www.twitter.com/recruitment180
Views: 703 Recruitment180
HCL Technologies Telephonic interview for PL/SQL developer
 
09:13
Here, you find the HCL Telephonic interview for PL/SQL developer position.
Views: 4399 Oracle PL/SQL
Oracle PL/SQL Tutorials | Introduction to Oracle SQL Developer | Mr.Vaman Deshmukh
 
10:33
Oracle PL/SQL Tutorials | Introduction to Oracle SQL Developer | Mr.Vaman Deshmukh ** For Online Training Registration: https://goo.gl/r6kJbB ► Call: +91-8179191999 ► Visit Our Website for Classroom Training: https://nareshit.in ► For Online Training: https://nareshit.com/ -------------------------- ► About NareshIT: "Naresh IT is having 14+ years of experience in software training industry and the best Software Training Institute for online training, classroom training, weekend training, corporate training of Hadoop, Salesforce, AWS, DevOps, Spark, Data Science, Python, Tableau, RPA ,Java, C#.NET, ASP.NET, Oracle, Testing Tools, Silver light, Linq, SQL Server, Selenium, Android, iPhone, C Language, C++, PHP and Digital Marketing in USA,Hyderabad, Chennai and Vijayawada,Bangalore India which provides online training across all the locations -------------------------- ► Our Online Training Features: 1.Training with Real-Time Experts 2.Industry Specific Scenario’s 3.Flexible Timings 4.Soft Copy of Material 5. Share Videos of each and every session. -------------------------- Please write back to us at [email protected]/[email protected] or Call us at USA: +1404-232-9879 or India: +918179191999 ** Check The Below Links** ► For Course Reg: https://goo.gl/r6kJbB ► Subscribe to Our Channel: https://goo.gl/q9ozyG ► Circle us on G+: https://plus.google.com/NareshIT ► Like us on Facebook: https://www.facebook.com/NareshIT ► Follow us on Twitter: https://twitter.com/nareshitech ► Follow us on Linkedin: https://in.linkedin.com/company/naresh-i-technologies ► Follow us on Instagram: https://www.instagram.com/nareshitech/ ----------------------------------------------------------------------------------------------------- #oraclevideos #sqltutorials #programmingvideos #oracletutorials #oracletrainingvideos
Careers and Training courses for SQL | SQL Developers are one of the highest paid employees in India
 
04:46
Get Recruitment Notifications of all private and govt jobs , Mock test details ,Previous year question papers only at Freshersworld.com – the No.1 jobsite for entry level candidates in India. (To register : http://freshersworld.com?src=Youtube ) – This video is all about “Careers and Training courses for SQL What actually it is SQL is a standard language for accessing and manipulating databases. What is SQL? • SQL stands for Structured Query Language • SQL lets you access and manipulate databases • SQL is an ANSI (American National Standards Institute) standard ________________________________________ What Can SQL do? • SQL can execute queries against a database • SQL can retrieve data from a database • SQL can insert records in a database • SQL can update records in a database • SQL can delete records from a database • SQL can create new databases • SQL can create new tables in a database • SQL can create stored procedures in a database • SQL can create views in a database • SQL can set permissions on tables, procedures, and views ________________________________________ Which companies are looking for this 1) DELL 2) J.P. Morgan 3) GOOGLE 4) NETCRACKER 5) and many more companies are looking for the same. Best way to learn this course There is a lot of material online and it is actually very difficult to separate the good from the bad. It is about dividing the task of "learning SQL" into a concrete set of actions followed by hand-picking of the material that suits your temper. 1. Database fundamentals: Spend some time on looking what a database is - understand how it works (what is a 'key'? what type of roles exist in a database? what is a table? etc.). 2. Relational databases: Relational databases are probably the most used database organization. It is fairly easy to comprehend so give it a couple of hours. 3. Data types: If you know nothing about data types - (If you cannot answer questions like what is a numeric(0,2)? or what is a string?) then you should definitely look into fundamentals about data types. Understanding the data types in SQL Server. 4. Joins methodology: Understanding how data-sets can be joined across tables and how you extract data. 5. Download SQL Server Express: Download the free version of MS SQL and create a database on your local computer. Salary after doing this course The average SQL Developer salary is $73,345 per year or $38 per hour. This is around 2.5 times more than the Median wage of the country. Entry level positions start at $51,000 while most experienced workers make up to $103,000. Related jobs Average salary Microsoft Server Developer $97,500 Developer Stored Procedures $70,000 Net Sql Developer $70,000 Lead Sql Developer $37,112 SQL Developer Salary(India) The average salary for a SQL Developer is Rs 372,127 per year. People in this job generally don't have more than 10 years' experience. Experience strongly influences pay for this job. Growth after getting job SQL (Structured Query Language) will be among the most desirable job skills in the years ahead. Surprisingly, it is also among the easiest to learn. Here's why: • All computerized businesses — from global banks to small town bakeries — need to have a database, almost all of which are managed using SQL.1 • SQL consistently ranks at — or very near — the top of the most in-demand IT skills.2 • SQL developers take home an average salary of $92,0003 and enjoy very bright career prospects. If this sounds awesome to you, then buckle up and start learning SQL basics! Freshersworld.com is the No.1 job portal for freshers jobs in India. Check Out website for more Jobs & Careers. http://www.freshersworld.com?src=Youtube Download our app today to manage recruitment when ever and where ever you want : Link :https://play.google.com/store/apps/details?id=com.freshersworld.jobs&hl=en ***Disclaimer: This is just a training video for candidates and recruiters. The name, logo and properties mentioned in the video are proprietary property of the respective organizations. The Preparation tips and tricks are an indicative generalized information. In no way Freshersworld.com, indulges into direct or indirect promotion of the respective Groups or organizations.
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: 833745 kudvenkat
SQL: Rank & Dense_rank functions
 
06:47
In this tutorial, you'll learn the difference between rank() and dense_rank() functions..
Views: 26030 radhikaravikumar
SQL Query Interview Questions
 
19:06
Video talks about SQL Query Interview Questions SQL Interview Questions SQL Interview Questions and answers top sql questions SQL real time scenario based interview questions Top SQL Interview Questions and answers Step by step SQL Training videos SQL Tutorial More videos at https://www.youtube.com/channel/UCgWvQ6cBxZwABl_hL48ayXg sample Code : --A. Select highest salary from employee table SELECT MAX(SAL) AS 'Max Salary' , MIN(Sal) AS 'Min Salary' FROM EMP -- B. Get the employee details who has highest salary SELECT * FROM EMP WHERE SAL=(SELECT MAX(SAL) FROM EMP) -- C. Get the second highest salary from employee table SELECT TOP 1 EMPName,SAL FROM ( SELECT TOP 2 EMPName,SAL FROM EMP ORDER BY SAL DESC) SUB ORDER BY SAL ASC -- D. Get the employees list who has the salary between x and y. SELECT * FROM EMP WHERE SAL Between 9000 and 13000 -- E. Get the highest salary on department wise SELECT DeptName,MAX(SAL) AS 'MAX SAL' FROM EMP E JOIN DEPT D ON E.DeptNo=D.DeptNo GROUP BY DeptName -- F. Get the highest salary, employee name along with department SELECT E.EmpName,SUB.DeptName,SUB.[Max Sal] FROM EMP E JOIN ( SELECT E.DeptNo, DeptName,MAX(SAL) AS 'Max Sal' FROM EMP E JOIN DEPT D ON E.DeptNo=D.DeptNo GROUP BY DeptName,E.DeptNo) SUB ON E.DeptNo=SUB.DeptNo AND E.Sal=SUB.[Max Sal]
Views: 17583 Training2SQL MSBI
SQL Tutorial - 45: Date & Time Functions (Part-1)
 
05:15
In this tutorial we'll see how we can add dates, subtract dates, view current date and current time using ADDDATE(), SUBDATE(), CURDATE() and CURTIME Functions respectively.
Views: 33395 The Bad Tutorials
How to Install Oracle SQL Developer
 
09:17
This video explains how to install SQL Developer. Oracle's SQL Developer is a free SQL IDE, which allows you to write and run SQL statements on an Oracle database. It can be used with Oracle Express, or the full version of Oracle database. In summary, the steps are: 1. Download SQL Developer from www.oracle.com 2. Optionally, download the JDK from the same page 3. Extract the ZIP files 4. Optionally, install the JDK 5. Run SQL Developer 6. Set up a connection to your database SQL Developer has improved over the last few years and it's a great IDE to use for your development. It's recommended by many in the industry, and it's easy to set up as well. If you enjoy this video, please like it and subscribe to my channel. Thanks!
Views: 1499 Database Star
Migrating Your Oracle Database to PostgreSQL - 2017 AWS Online Tech Talks
 
33:07
Learning Objectives: - Learn about the capabilities of the PostgreSQL database - Learn about PostgreSQL offerings on AWS - Learn how to migrate from Oracle to PostgreSQL with minimal disruption The PostgreSQL database has become very popular in recent years for its powerful functionality and high degree of compatibility with commercial databases. But migrating from Oracle or other databases to PostgreSQL has often been difficult and time-consuming. In this session, we’ll cover core capabilities and differences to be aware of, learn about PostgreSQL deployment options on Amazon Relational Database Service and Amazon Aurora, and see how to easily migrate your schemas and your data with minimal downtime.
Views: 4881 AWS Online Tech Talks
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: 162521 Joes2Pros SQL Trainings
Ms SQL Server DBA Experienced Interview Questions And Answers - 06
 
29:11
Ms SQL Server DBA Experienced Interview Questions And Answers - 06 This is the actual call recording of an interview for an experienced Ms SQL Server DBA sql interview questions and answers for experienced sql server interview questions and answers for experienced sql interview questions for experienced sql server interview questions for experienced sql interview questions and answers for experienced pdf sql query interview questions and answers for experienced sql queries interview questions and answers for experienced sql server interview questions and answers for experienced pdf sql server 2008 interview questions and answers for experienced sql server dba interview questions and answers for experienced sql dba interview questions and answers for experienced interview questions on sql for experienced sql server interview questions for experienced professionals sql server 2008 interview questions and answers for experienced pdf sql server dba interview questions and answers for experienced pdf interview questions on sql server for experienced sql server dba interview questions for experienced sql questions and answers for experienced sql queries interview questions for experienced sql experienced interview questions sql server experienced interview questions sql interview questions experienced t-sql interview questions for experienced sql interview queries for experienced sql server 2008 interview questions for experienced sql server questions for experienced interview questions on sql queries for experienced sql questions for experienced sql queries asked in interviews for experienced sql experienced interview questions and answers sql interview questions for experienced and answers sql server experienced interview questions and answers sql server interview questions for 2 years experienced sql server developer interview questions for experienced interview questions on sql server 2008 with answer for experienced sql server interview questions interview questions on sql server sql server questions sql server 2012 interview questions sql server interview question interview questions for sql server interview questions sql server sql server replication interview questions sql server ssis interview questions interview questions in sql server interview question on sql server sql server mirroring interview questions sql server question interview questions on sql server 2012 questions on sql server sql server security interview questions interview questions of sql server interview question for sql server sql server optimization interview questions sql server bi interview questions sql server latest interview questions sql server performance interview questions sql server index interview questions sql server admin interview questions interview question sql server sql server interview questions book interview question of sql server sql server questions for interview sql server interview questions for 6 years
Views: 28314 Real Time Interviews
DBBest - Oracle to SQL Server Migrations - Our Services
 
01:40
We at DB Best has built expertise of many years converting hundreds of applications and databases between Oracle, Sybase, DB2, MySQL, Informix, Access mainly to SQL Server. Learn more: http://www.DBbest.com/services/database-and-app-migration/

Writing letter to judge uk
Custom writing service reviews
Jobs applications for 15 year olds in memphis tn
Cover letter job references sheet
Term papers writing service