Home
Search results “Oracle years function”
Oracle TO_TIMESTAMP Function
 
01:31
https://www.databasestar.com/oracle-to_timestamp/ The Oracle TO_TIMESTAMP function can be confusing, but we’ll explain it in this video. This function allows you to convert a string value into a TIMESTAMP value. A TIMESTAMP value is a type of DATE, but has a few components: - A date, including day, month, and year - A time, including hours, minutes, seconds, and fractional seconds This is a useful data type because it allows you to store a time down to fractions of a second. The syntax of the TO_TIMESTAMP function is: TO_TIMESTAMP ( input_string [, format_mask] [, nls_param] ) The input_string parameter is the string you want to convert. The format_mask is where you specify the format of the input_string parameter. This is so you can specify the input_string in a variety of formats, and just use this format_mask to indicate which format it is in. The nls_param parameter is another optional parameter, and allows you to specify the returning language of the month and day names. The default format will depend on the region you’re running your database in. In my example (using Oracle Express in Australia), the default format is ‘DD-MM-RRRR HH:MI:SS AM’. For more information on the Oracle TO_TIMESTAMP function, including the SQL used in this video, read the related article here: https://www.databasestar.com/oracle-to_timestamp/
Views: 377 Database Star
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
SQL: Extract function
 
03:38
In this tutorial, you'll learn how to make use of extract function. 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: 3803 radhikaravikumar
Oracle MONTHS_BETWEEN Function
 
02:17
https://www.databasestar.com/oracle-months_between/ The Oracle MONTHS_BETWEEN function allows you to find the number of months between two dates. You can enter two dates and the function returns the difference. This function is often used as part of other calculations. Sometimes you’ll want to know the difference between two dates to perform other functions. The syntax of the MONTHS_BETWEEN function is: MONTHS_BETWEEN(date1, date2) What do these two parameters mean? The function performs date1 minus date2. So, if date1 is larger, the result is positive. If date2 is larger, then the result is negative. What data type is returned? It depends on the values you provide. If the dates are both on the same day of the month (e.g. both on the 10th of the month), then the result is an integer or whole number. If not, then the result will be a decimal value. For more information on the MONTHS_BETWEEN function, including the code used in this video and examples, read the related article here: https://www.databasestar.com/oracle-months_between/
Views: 887 Database Star
Oracle FROM_TZ Function
 
01:45
https://www.databasestar.com/oracle-timezone-functions/ The Oracle FROM_TZ function is used to convert a value in a TIMESTAMP data type, and a specific TIME ZONE, to a TIMESTAMP WITH TIME ZONE value. It’s a helpful conversion function if you work with times and time zones a lot. The syntax of the FROM_TZ function is: FROM_TZ ( timestamp_value, timezone_value ) The parameters of this function are: - timestamp_value: the value in a TIMESTAMP format to convert. - timezone_value: this is the timezone value that the timestamp_value will be converted in to. If you want to know what values can be used as a timezone value, you can look in the database view here: SELECT * FROM v$timezone_names; For more information about the Oracle FROM_TZ function, including all of the SQL shown in this video and the examples, read the related article here: https://www.databasestar.com/oracle-timezone-functions/
Views: 61 Database Star
Oracle Tutorial Date Function - 2
 
07:10
Oracle Date Function, Order by Month Year. Getting employee count hired month, yearwise and order by hiring month and year. SQL Used in the video below. select * from employees order by hire_date; select hire_date,to_char(hire_date,'Month,YYYY') from employees; select to_char(hire_date,'Month,YYYY')Month_Year,count(*) No_Of_Employees from employees group by to_char(hire_date,'Month,YYYY') order by to_char(hire_date,'Month,YYYY') select to_char(hire_date,'Month,YYYY')Month_Year,count(*) No_Of_Employees from employees group by to_char(hire_date,'Month,YYYY') order by to_date(to_char(hire_date,'Month,YYYY'),'Month,YYYY') select replace(to_char(hire_date,'Month,YYYY'),' ','')Month_Year,count(*) No_Of_Employees from employees group by to_char(hire_date,'Month,YYYY') order by to_date(to_char(hire_date,'Month,YYYY'),'Month,YYYY')
Views: 50 Ganesh Anbarasu
Oracle CURRENT_TIMESTAMP Function
 
02:37
https://www.databasestar.com/oracle-date-functions/ The Oracle CURRENT_TIMESTAMP function will display the current date and time in the session time zone. Just like the CURRENT_DATE function, it uses the session time zone, which is where you logged in from. This could be different to the database time zone. The syntax of the CURRENT_TIMESTAMP function is: CURRENT_TIMESTAMP ( [precision] ) The return type of this function is TIMESTAMP WITH TIME ZONE. The precision parameter is optional, and it lets you specify the number of fractional seconds to return. If this is omitted, it uses the default of 6. It’s different to the SYSTIMESTAMP function, because CURRENT_TIMESTAMP returns the session timezone, and SYSTIMESTAMP returns the database time zone. So, if I’m logging in from Melbourne, Australia, and the database is in London, England, then the CURRENT_TIMESTAMP will return a date and time that’s 10 hours ahead of SYSTIMESTAMP, and in a different time zone. It may be on the same day, or it could be a different day, depending on when I run the function. You can perform arithmetic on this function just like any other date value (e.g. CURRENT_TIMESTAMP - 7 for 7 days ago). However, it might be better to use interval data types so you can keep the original data type. For more information about the Oracle CURRENT_TIMESTAMP function, including all of the SQL shown in this video and the examples, read the related article here: https://www.databasestar.com/oracle-date-functions/
Views: 218 Database Star
Oracle ADD_MONTHS Function
 
03:15
https://www.databasestar.com/oracle-add_months/ The Oracle ADD_MONTHS allows you to add a specified number of months to a date value, and return the new date value. It’s great for performing calculations on dates, or date arithmetic, which can be hard in many different programming languages. The syntax of the ADD_MONTHS function is: ADD_MONTHS ( input_date, number_months ) The function returns a DATE value. The parameters of this function are: - input_date (mandatory): This is the starting date, or the date that you will add a number of months to. - number_months (mandatory): This is an integer value that represents the number of months to add to input_date. The input_date can be any datetime value, or even a character value that can be converted to a date. Also, the number_months can be any number value, or a character value that can be converted to a number. What if the number of days in the two months are different? For example, adding a month to Jan 31 could result in Feb 31, which does not exist. Well, in this case, Oracle would work out that the date does not exist, and use the last date of the month (e.g. Feb 28). You can also provide a negative value for ADD_MONTHS to subtract months from the specified date. For more information about the Oracle ADD_MONTHS function, including all of the SQL shown in this video and the examples, read the related article here: https://www.databasestar.com/oracle-add_months/
Views: 418 Database Star
Oracle TO_TIMESTAMP_TZ Function
 
01:43
https://www.databasestar.com/oracle-timezone-functions/ The Oracle TO_TIMESTAMP_TZ function can be confusing, but we’ll explain it in this video. This function allows you to convert a string value into a TIMESTAMP WITH TIME ZONE value. A TIMESTAMP WITH TIME ZONE value is a type of DATE, but has a few components: - A date, including day, month, and year - A time, including hours, minutes, and seconds - A time zone, which is the number of hours and minutes difference from GMT This is a useful data type because it allows you to store dates in different time zones, and allow users in other time zones to see the data in a way that makes sense to them. The time zone part is the difference from GMT. This means that a “+7:00” is 7 hours ahead of GMT (e.g. Bangkok) and “-5:00” is 5 hours behind GMT (e.g. US Eastern Standard Time). The syntax of the TO_TIMESTAMP_TZ function is: TO_TIMESTAMP_TZ ( input_string [, format_mask] [, nls_param] ) The input_string parameter is the string you want to convert. The format_mask is where you specify the format of the input_string parameter. This is so you can specify the input_string in a variety of formats, and just use this format_mask to indicate which format it is in. The nls_param parameter is another optional parameter, and allows you to specify the returning language of the month and day names. For more information on the Oracle TO_TIMESTAMP_TZ function, including the SQL used in this video, read the related article here: https://www.databasestar.com/oracle-timezone-functions/
Views: 86 Database Star
Functions – date_diff()
 
06:36
This video reviews the date_diff() function available in Oracle Service Cloud Analytics. You will learn what the date_diff() function does and how to configure it for use in your reports. Also covered are subtle tips and tricks like the value formatting, nesting of the date_diff function in expressions and a couple of business use cases examples to help you think about how you might use this function in your business reporting.
How to add days months or years to date using DateAdd function SQL Server
 
04:22
Published on Sep 10, 2017: In this video tutorial, we will learn to add subtract days,months, quarters and years from any given date. We can use the same logic for other date parts mentioned in the Microsoft documentation. Link to the microsoft documentation https://goo.gl/7M8Yjc Example 1 SQL Used: Select getdate() ,DateAdd(day,10,getdate())DayAdd --Add Day(s) ,DateAdd(day,-10,getdate())DaySubtract --Subtract Day(s) , DateAdd(month,1,getdate())MonthAdd--Add Month(s) ,DateAdd(month,-1,getdate())MonthSubtract--Subtract Month(s) ,DateAdd(year,1,getdate())YearAdd--Add Year(s) ,DateAdd(year,-1,getdate())YearSubtract--Subtract Year(s) Example 2 SQL Used: SELECT [FullDateAlternateKey] ,DateAdd(day,10,[FullDateAlternateKey])DayAdd --Add Day(s) ,DateAdd(day,-10,[FullDateAlternateKey])DaySubtract --Subtract Day(s) , DateAdd(month,1,[FullDateAlternateKey])MonthAdd--Add Month(s) ,DateAdd(month,-1,[FullDateAlternateKey])MonthSubtract--Subtract Month(s) ,DateAdd(year,1,[FullDateAlternateKey])YearAdd--Add Year(s) ,DateAdd(year,-1,[FullDateAlternateKey])YearSubtract--Subtract Year(s) FROM [AdventureWorksDW2012].[dbo].[DimDate] Previous Video:https://youtu.be/_voKLD97XH0 SUBSCRIBE to learn more about Power BI,Power Query, Power Pivot, Excel and SQL Server! https://www.youtube.com/channel/UCYYHFZpm5GbaOmQKDNSTGLw Download the sample database used for the demo here: https://goo.gl/SVyVmT Our Playists: SQL Playlist :https://goo.gl/PS5Ep6 DAX PlayList : https://goo.gl/S4W41D Power BI PlayList: https://goo.gl/dXxvnB Power Query Playlist: https://goo.gl/5QS7P4 ABOUT DAGDOO: Website: Home Page: http://www.dagdoo.org/ Power BI Tutorials: http://www.dagdoo.org/excel-learning/tutorial-power-bi-desktop/ Questions? Comments and SUGESTIONS? You will find me here: Twitter: @dagdooe Category: Science & Technology License: Standard YouTube License
Views: 604 Learn 2 Excel
Oracle Forms Application Analysis - The TABLE IMPACT FUNCTION
 
03:43
This Video describes how you can find all Impacts of a Table or a specific Column within your entire Oracle Forms Application using PITSS.CON ▼▼▼▼▼▼▼▼▼▼ MORE DETAILS BELOW ▼▼▼▼▼▼▼▼▼▼▼ With the PITSS.CON Application Analysis, Oracle Forms and Reports applications of all sizes and levels of complexity can be analyzed accurately and quickly, allowing developers to take the guesswork and risk out-of-application development and maintenance. Using Oracle’s own API and the analytical strength of a centralized data repository, PITSS.CON Application Analysis performs a fast, detailed Oracle Forms analysis of even the most complex and comprehensive applications. This can be used for powerful what-if simulations, sophisticated research, and comprehensive reporting. The in-depth insight applies at every level, from day-to-day work to large-scale re-engineering and migration projects. This allows the development teams to better understand connections and implement requirements, ensuring that your investment in Oracle Forms and Reports applications will pay off for years to come. ▼▼▼ FUNCTIONAL HIGHLIGHTS ▼▼▼ ►Atomization (parsing) of all loaded program objects ►Automatic analysis of the entire application, including all menus, libraries, reports, database elements, and further development objects ►Representation of all components and structures of Oracle Applications from the mask field to the table column ►Representation of all Oracle Forms dependencies, including the use of program functions, database or module objects ►Complete dependence analysis for pending changes by identifying affected systems and side effects ►Implementation of structural changes of columns and adjustment of the relevant programs ►Export of analysis results as text, HTML or PDF file for software documentation ▼▼▼ LEARN MORE ABOUT APPLICATION ANALYSIS ▼▼▼ ►Website: Application Analysis (English): https://pitss.com/products/pitss-con-overview/application-analysis/ ►Website: Application Analysis (German): https://pitss.com/de/pitsscon-application-analysis/ ►Video: What is an Impact Analysis: https://youtu.be/PFJhM5CV9JA _______________________________________________________________________________ ▼▼▼ HOW TO FIND US ▼▼▼ PITSS US/Canada/UK: https://pitss.com/ PITSS D/A/CH: https://pitss.com/de/ ▼▼▼ CONNECT & STAY UP TO DATE ▼▼▼ Twitter: https://twitter.com/PITSS_GmbH Google+: https://plus.google.com/116912679338809155946/posts LinkedIn US: https://www.linkedin.com/company/pitss-america-llc LinkedIn De: https://www.linkedin.com/company/pitss-gmbh
Views: 106 PITSS
SQL YEAR function - how to use SQL YEAR function
 
00:52
The SQL Server YEAR function returns a four-digit year (as a number) given a date value. visit Dose for excel Add-In website: http://www.zbrainsoft.com/ Visit our channel: https://www.youtube.com/channel/UCI4bMWYzrBTs47KINXL92Kw
Bisham's Set @ Oracle 10th Anniversary Function
 
10:26
Surprise performance at the Oracle Signs 10th Anniversary Dinner and Awards Function at Toppers Grand Bazaar. Dedicated to my mom. First time on stage in about 18 years. 22nd November 2014. Thank you so much to the awesome guys of @5Miles2Midnight for being so accommodating in making this happen! Please check them out on Facebook https://www.facebook.com/5milestomidnight http://www.weare5m2m.com/
Views: 229 OracleSigns
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
SQL 36, trunc function
 
02:36
What you can do with trunc function in SQL
Views: 3955 hammadshams
Tutorial membuat stored function hitung luas persegi di Oracle SQL
 
02:45
Tutorial membuat stored function hitung luas persegi di Oracle SQL
Views: 154 Muhammad Derry
Oracle PL/SQL Tutorials | Function in Oracle | by Mr.Vaman Deshmukh
 
04:51
Oracle PL/SQL Tutorials | Function in Oracle | by 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/
Tutorial#40 NVL Function in  oracle SQL with example
 
06:45
Explaining NVL SQL NULL function / Oracle Function NVL Function, It Replaces Null Values With some Values or string. or how to use NULL Values in Oracle SQL or what is NVL Function explain with the example or nvl function in SQL Assignment link : https://drive.google.com/open?id=1lR8CDiCt7vdV1EogFtKc654fAeCGBgdK 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. Link for assignment: UPPERfunction in SQL https://drive.google.com/open?id=1ibjDTDX-CiPUShpf8j9kLkLjkYRdN9_e follow me on: Facebook Page: https://www.facebook.com/LrnWthr-319371861902642/?ref=bookmarks Contacts Email: [email protected] Instagram: https://www.instagram.com/equalconnect/ Twitter: https://twitter.com/LrnWthR #NVLFunctionInOracle #OracleSQLTutorial #SQLCourseForBeginner
Views: 46 EqualConnect Coach
Oracle DENSE_RANK Function
 
04:09
https://www.databasestar.com/oracle-dense_rank/ The Oracle DENSE_RANK function allows you to calculate a rank of a row in a group of rows. It returns this rank as a NUMBER value. This function can be used as either an analytic or an aggregate function, and the syntax depends on how you use it. As an aggregate function it looks like this: DENSE_RANK ( expr, [expr(n)] ) WITHIN GROUP ( ORDER BY (order_expr [ASC|DESC] [NULLS FIRST|LAST] ) These parameters are: - expr: this is the value to search for in a particular table. You can specify multiple search values, and just separate them by a comma. - order_expr: this is used to order the expr values by, because you get a different results depending on what order you rank the values in. - NULLS FIRST or LAST: this is where you can specify if you want to have NULL values appear at the top of your ranking order or at the bottom. As an analytic function, it looks like this: DENSE_RANK() OVER ( [query_partition_clause] order_by_clause) The parameters are: - query_partition_clause: this is the expression that the ranking is “grouped” by, as analytic functions allow you to group data within rows. - order_by_clause: this is the expression to order your results by to determine a rank. For this function, if two records have the same sort or rank position, they will have the same RANK value. It won’t cause a gap in the rankings, unlike the RANK function which does cause a gap. For more information about the Oracle DENSE_RANK function, including all of the SQL shown in this video and the examples, read the related article here: https://www.databasestar.com/oracle-dense_rank/
Views: 310 Database Star
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: 3634 Pinal Dave
02 Extract Oracle
 
00:55
Views: 71 GISMagazine
TO_CHAR(datetime) Function in SQL Query
 
03:59
TO_CHAR (datetime) : TO_CHAR (datetime) converts a datetime datatype to a value of VARCHAR2 datatype in the format specified by the date format. The following is a list of valid parameters when the TO_CHAR function is used to convert a date to a string. These parameters can be used in many combinations. YEAR Year, spelled out YYYY 4-digit year YYY Last 3 digits of year. YY Last 2 digits of year. Y Last 1 digit of year. IYYY 4-digit year based on the ISO standard Q Quarter of year (1, 2, 3, 4; JAN-MAR = 1). MM Month (01-12; JAN = 01). MON Abbreviated name of month. MONTH Name of month, padded with blanks to length of 9 characters. RM Roman numeral month (I-XII; JAN = I). WW Week of year (1-53) where week 1 starts on the first day of the year and continues to the seventh day of the year. W Week of month (1-5) where week 1 starts on the first day of the month and ends on the seventh. IW Week of year (1-52 or 1-53) based on the ISO standard. D Day of week (1-7). DAY Name of day. DD Day of month (1-31). DDD Day of year (1-366). DY Abbreviated name of day. J Julian day; the number of days since January 1, 4712 BC. HH Hour of day (1-12). HH12 Hour of day (1-12). HH24 Hour of day (0-23). MI Minute (0-59). SS Second (0-59). SSSSS Seconds past midnight (0-86399). FF Fractional seconds. Thanks for watching...:)
Views: 10214 WingsOfTechnology
THE ORACLE - Keeper of Wisdom - HD FEATURE FILM
 
53:40
From UFOTV®, accept no imitations. Cloaked in secrecy for over 400 years, the State Oracle of Tibet has been a strange and mystical aspect of the Tibetan Buddhist tradition. This ancient spirit, which has inhabited a succession of thirteen human mediums, advises the Dalai Lama on matters of public and religious policy. To witness the eerie spectacle of a medium entering a trance state and being possessed by the Oracle is to confront profound questions about the very nature of human consciousness. With permission from the Dalai Lama that had never been granted before, The Oracle explores the ancient practice of consulting spirits. NOW on DVD and LOADED with Bonus Features, Cat# U693, Go to http://www.UFOTV.com.
Extract Oracle data
 
01:39
Extract Oracle data with customized tasks
Views: 202 TLIUpdates
RANK and DENSE RANK functions in ORACLE
 
02:01
RANK and DENSE RANK functions in ORACLE... Oracle tutorials for biginners....
Views: 143 CONNECT TO LEARN
ADD_MONTHS Function in SQL Query with Example
 
02:32
ADD_MONTHS(): The Oracle/PLSQL ADD_MONTHS function returns a date plus n months. Syntax: ADD_MONTHS( date1, n ) Arguments: date1 is the starting date (before the n months have been added). n is the number of months to add to date1. Example: Let's look at some Oracle ADD_MONTHS function examples and explore how you would use the ADD_MONTHS function in Oracle/PLSQL. ADD_MONTHS('01-Aug-03', 3) would return '01-Nov-03' ADD_MONTHS('01-Aug-03', -3) would return '01-May-03' ADD_MONTHS('21-Aug-03', -3) would return '21-May-03' ADD_MONTHS('31-Jan-03', 1) would return '28-Feb-03' Thanks for watching..:)
Views: 1104 WingsOfTechnology
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: 169297 kudvenkat
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: 35736 Techtud
Robotic Process Automation - Oracle WMS 3PL for receiving function
 
01:43
Robotic Process Automation - Oracle WMS 3PL for receiving function By Dia Rashid
Views: 87 Dia Rashid
Oracle DV - Use TimestampDiff to Calculate Interval Between Two Dates
 
01:46
This video shows simple way to leveage TimestampDiff function in Oracle DV to calculate time interval between two dates. Download the latest version of DV today https://www.oracle.com/technetwork/middleware/oracle-data-visualization/downloads/oracle-data-visualization-desktop-2938957.html.
Views: 153 Oracle Analytics
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: 168859 Joes2Pros SQL Trainings
Oracle Database 12c: Introduction to SQL - Creating Joins with the USING Clause
 
05:02
This video is a sample from Skillsoft's video course catalog. After watching it, you will be able to use the USING clause to specify columns used for an equijoin to retrieve records in a SQL statement. Tracy Odendaal is an Oracle Database 11g Administrator Certified Master with 18 years’ experience as an Oracle database administrator, focusing on all areas of database administration. Tracy works closely with clients to design and implement Oracle solutions using DataGuard, GoldenGate, Oracle Database Appliance, Real Application Clusters, and Oracle Enterprise Manager. Skillsoft is a pioneer in the field of learning with a long history of innovation. Skillsoft provides cloud-based learning solutions for our customers worldwide, who range from global enterprises, government and education customers to mid-sized and small businesses. Learn more at http://www.skillsoft.com. https://www.linkedin.com/company/skillsoft http://www.twitter.com/skillsoft https://www.facebook.com/skillsoft
Views: 346 Skillsoft YouTube
Oracle Database Express SQL Tutorial 5 (dates)
 
09:26
We look at dates in this product, We use the TO_DATE function inside of an INSERT command to store a date field and BETWEEN to query if it falls between two dates.
Views: 342 Graham Roberts
SQL YEAR() Function
 
01:25
The SQL YEAR() is a function, and returns or extract year portion(a four digit number) of a given input date value.
Views: 242 suresh babu
Previous Year - Non Governed - Lag function
 
00:45
How to calculate Previous Year data in MicroStrategy. This example shows how to leverage the Analytical Engine of MicroStrategy to do it quick and dirty in a dashboard.
Views: 323 HF Chadeisson
LAST VALUE function in SQL Server
 
05:35
last_value function in sql server 2008 sql server last_value function returns incorrect data sql server last_value function example sql server last_value function with partition example LAST_VALUE function in SQL Server In this video we will discuss LAST_VALUE function in SQL Server. LAST_VALUE function Introduced in SQL Server 2012 Retrieves the last value from the specified column ORDER BY clause is required PARTITION BY clause is optional ROWS or RANGE clause is optional, but for it to work correctly you may have to explicitly specify a value Syntax : LAST_VALUE(Column_Name) OVER (ORDER BY Col1, Col2, ...) LAST_VALUE function not working as expected : In the following example, LAST_VALUE function does not return the name of the highest paid employee. This is because we have not specified an explicit value for ROWS or RANGE clause. As a result it is using it's default value RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW. SELECT Name, Gender, Salary, LAST_VALUE(Name) OVER (ORDER BY Salary) AS LastValue FROM Employees LAST_VALUE function working as expected : In the following example, LAST_VALUE function returns the name of the highest paid employee as expected. Notice we have set an explicit value for ROWS or RANGE clause to ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING This tells the LAST_VALUE function that it's window starts at the first row and ends at the last row in the result set. SELECT Name, Gender, Salary, LAST_VALUE(Name) OVER (ORDER BY Salary ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING) AS LastValue FROM Employees LAST_VALUE function example with partitions : In the following example, LAST_VALUE function returns the name of the highest paid employee from the respective partition. SELECT Name, Gender, Salary, LAST_VALUE(Name) OVER (PARTITION BY Gender ORDER BY Salary ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING) AS LastValue FROM Employees Text version of the video http://csharp-video-tutorials.blogspot.com/2015/10/lastvalue-function-in-sql-server.html Slides http://csharp-video-tutorials.blogspot.com/2015/10/lastvalue-function-in-sql-server_9.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: 32809 kudvenkat
Tim Hall - Oracle Database expert
 
01:40
Tim is an ACE Director and he usually present at the Oracle Technology tour Latin America about his latest experiences working with SQL and Databases.
Views: 187 OracleAmericaLatina
#Kscope15 Interview: Steven Feuerstein, Oracle Corporation
 
10:54
Oracle Developer Outreach Advocate Todd Trichler interviewed #Kscope15 presenter Steven Feuerstein of Oracle Corporation. For more information on Kscope15 visit http://kscope15.com. To learn about ODTUG go to http://odtug.com and to be a part of the best Oracle developer conference in 2016 go to Kscope16 http://kscope16.com. Bio: Steven Feuerstein, Oracle Corporation Steven Feuerstein is an expert on the Oracle PL/SQL language, having written 10 books on PL/SQL, including Oracle PL/SQL Programming and Oracle PL/SQL Best Practices (all published by O'Reilly Media). Steven is an Architect for Oracle Corporation, leading a team of evangelists with a mission of helping users leverage Oracle Database as a powerful application development platform. Steven has been developing software since 1980, originally spent five years with Oracle (1987-1992), and was PL/SQL Evangelist for Quest Software (and then Dell) from January 2001 to February 2014, at which point he returned joyfully to Oracle Corporation. He was one of the original Oracle ACE Directors and writes regularly for Oracle Magazine, which named him the PL/SQL Developer of the Year in both 2002 and 2006. He is also the first recipient of ODTUG's Lifetime Achievement Award (2009). Read Steven's commentary on PL/SQL and other Oracle technologies at stevenfeuersteinonplsql.blogspot.com. Session: Cool Package Features You May Not Know About Topic: Database Development Packages are the building blocks of any well-designed PL/SQL-based application. That means that most PL/SQL developers are at least familiar with the basics of packages. This session will first make sure you aware of key package features, such as the initialization section, oveloading, and package level data, and then explores lesser-known features of packages including serialization of package data and whitelisting access to packages (new to 12.1 PL/SQL). Back to Top PL/SQL Developers, the Most Important Developers on Earth: Part 1 & 2 Topic: Database Development It's a mobile, app-y, Internutty kind of world - does PL/SQL still have a role to play? You bet it does! And the way we write our PL/SQL is more important than ever before. This special two-part presentation will focus on using PL/SQL to build hiqh-quality and highly efficient APIs to data and the business rules that form the foundation of your applications. And because those APIs are going to be around for a while, you'll get top tips for writing highly maintainable code, too.
Views: 238 ODTUG
12강 oracle 11g SQL SQL 날짜함수(오라클 date function)
 
34:45
1. 처음 시작하는 MySQL DataBase https://www.udemy.com/softcampus-mysql/?couponCode=SOFTMYSQL 2. 처음시작하는 구글 공식 개발 언어 : 코틀린(Kotlin) https://www.udemy.com/softcampus-kotlin/?couponCode=SOFTKOTLIN 유데미에서 서비스 되는 소프트캠퍼스 강의 아래 경로를 통해 수강신청하시면 무조건 $9.99에 결재 됩니다. 3. Mobile App UI UX GUI Design Tutorials(모바일 앱 UX UI GUI디자인 실무) 할인쿠폰 https://www.udemy.com/mobpp-uxui-design-working-level-uxui/?couponCode=SOFTUXUI 4. 코틀린 기반 안드로이드 기본(Kotlin for Android: Beginner) 과정 https://www.udemy.com/sofrtcampus_adroid/?couponCode=SOFT_KAD 5. 유니티 클릭커 게임 과정 https://www.udemy.com/unity3d-clicker/?couponCode=SOFTCLICKER 6. 개발자 및 디자이너를 위한 HTML & HTML5 Tutorials https://www.udemy.com/softcampus-html5/?couponCode=SOFTHTML 7. node.js server Tutorials https://www.udemy.com/nodejs-server-tutorials/?couponCode=SOFTNODE 8. 처음시작하는 JQuery programming https://www.udemy.com/softcampus-jquery/?couponCode=SOFTJQ 9. 처음시작하는 JavaScript Tutorials https://www.udemy.com/softcampus-javascript/?couponCode=SOFTJAVAST 10. 개발자 및 디자이너를 위한 CSS & CSS3 Tutorials https://www.udemy.com/css-css3-tutorials/?couponCode=SOFTCSS 11. 처음시작하는 파이썬(Python) https://www.udemy.com/python-soft/?couponCode=SOFTPYTHON 12. unity 3D(유니티 3D) defense game(디펜스 게임) 할인 쿠폰 https://www.udemy.com/softcampus-unitydefense/?couponCode=SOFTDUNITY 강사 : 김일한 (주)소프트캠퍼스 http://www.softcampus.co.kr 더많은 무료 강의는 사이트에서 확인하실수 있습니다. 1강 오라클 데이터 베이스 구조 2강 오라클 자격증 종류 3강 데이터베이스 설치 4강 select 기능과 타입 5강 SQL 연산자 6강 SQL 조건 연산자 7강 where query 8강 논리연산자,Between in 9강 정렬(like,sort) 10강 주요함수, 숫자함수 11강 SQL 문자 함수 12강 날짜함수 13강 변환함수 14강 데이터 함수의 적용 15강 SQL 조건식 16강 그룹 함수 집계 데이터 17강 GROUP BY 18강 HAVING 19강 join data 20강 slef join 21강 Outer join 22강 Sub Join 23강 Sub query 24강 Sub query 25강 set 26강 set 27강 set 28강 DML 29강 DML 30강 COMMIT ROLLBACK 31강 DDL 32강 DDL 33강 데이터 무결성을 위한 제약 조건 34강 View 35강 시권스 36강 인덱스 37강 사용자 생성 38강 권한 부여 39강 객체권한 40강 Review 41강 Review 42강 Review
Views: 1004 소프트캠퍼스
Oracle PL/SQL Tutorials | PL/ SQL Blocks | by Mr.Vaman Deshmukh
 
06:18
Oracle PL/SQL Tutorials | PL/ SQL Blocks | by 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/ #PLSQL #BLOCKS #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/
Ranking Function Part-1| MSSQL Training | Mr.Sudhakar L
 
16:21
** 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-dba-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/nares... ? Follow us on Instagram: https://www.instagram.com/nareshitech/
Views: 5821 Naresh i Technologies
Oracle Database11g tutorials 11: SQL case manipulation function in Oracle Database
 
04:38
Part 2 SQL functions- character function -case manipulation functions Previous Video Link :: http://youtu.be/5rx8Q4x4-qI Tool used in this tutorial is command prompt. This tutorial series is part of SQL expert exam certification training. if you are preparing for SQL certification you can use my tutorials. This SQL Tutorial is a part of free training. Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage https://copy.com?r=j7eYO7 Contacts E-Mail [email protected] Twitter https://twitter.com/rebellionrider Instagram http://instagram.com/rebellionrider Facebook. https://www.facebook.com/imthebhardwaj Linkedin. http://in.linkedin.com/in/mannbhardwaj/ Thanks for linking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com ------------------------------------------------------------------------------------- As discuss in last video we have 3 case manipulation functions. In case you miss the SQL functions intro video you can find the link in the description below. First let's see what these functions are. Upper (): This function takes a parameter converts it into uppercase and returns the new string. Initcap (): this function also takes parameter and converts the initial letter of or parameter into uppercase and returns the new string. Lower (): This function takes a parameter converts it into lowercase and returns the new string. Ok let's do some practical For this practical we will be using 2 tables First is dual table Which is a dummy table provided by oracle? And I have created another table again by the name of example. This will be our second table. Let's start with SQL function upper ( ); SELECT upper('hello world') FROM dual; As you can see I have used "hello world" completely in lowercase as parameter to SQL upper function. Execute it. Here, our result has given us a completely new hello world string which is in uppercase. Similarly you can also use SQL upper function to perform other DML Let's try This time we will work on our second table EXAMPLE; insert into example values (upper('manish')); first parentheses for values and second for SQL function upper. Let's check the result. As you can see here inserted value is in upper case. Lets compare it with simple insert query Insert into example values ('manish'); Execute it, i think now it's clear that when we perform simple insert DML the inserted value will be the same you provide. Similarly let's try SQL function initcap(); SELECT initcap('hello world') FROM dual; As you see here in result the initial letters of string hello world are in uppercase. Let's do the insert query insert into example values (initcap('hello world')); initial letters of string also are in uppercase. Let's try SQL function lower(); This time we have to write our hello world in all caps. SELECT lower('HELLO WORLD') FROM dual; Execute String totally in lower case. Similarly you can user SQL function lower in other DML like insert and all.
Views: 85662 Manish Sharma
Subramanium Arumugam, Head--Global HR, Bharti Airtel at Oracle CloudWorld 2014
 
03:09
At Oracle CloudWorld 2014, Subramaniam Arumugam talks about how HR function has evolved substantially in the recent years, the benefits of automating HR processes and his views on how deploying HR tools on the cloud would benefit the businesses
Views: 242 Oracle India
Me on a dance event at Oracle Office Function
 
08:44
We are performing 4 dance styles - 1. Spanish - Original Spanish song 2. Contemporary - "Ore manwa tu toh bawra hai" 3. Bollywood - "Kudiyanu thagle" 4. Hip hop - Begging , from step up 3
Views: 1388 Rumpa Maji Nath
Office function.... 50 years celebration..
 
01:14
Plzz share it...
Views: 5 tausif momin
Date Function |  Lesson NO - 7 الدرس السابع الدوال التاريخيه
 
17:29
Free Oracle Developer online course سكوال function sql date function in excel, date function in excel 2010, date function in excel 2013, date functions in sql, date functions in oracle, date function in excel 2007, date function in qlikview, date functions in sql server, date function in php, date function in access, date function in excel, date function in excel 2010, date function in excel 2013, date function in excel 2007, date function in qlikview, date function in sql, date function in access, date function in oracle, date function in php, date function in sql server, date function in access, date function in access 2007, date function excel, date function excel 2013, date function in excel 2007, date function in excel 2010, date and time function in excel, edate function in excel, date function in excel, date function in excel 2010, date function in excel 2013, date function in excel 2007, date function in qlikview, date function in sql, date function in access, date function in oracle, date function in php, date function in sql server, mukunda audio function date, date function in oracle, php date function, date function in qlikview, date functions in sql, date functions, date functions in excel, date functions in oracle, date functions in excel 2010, date functions in sql server, date functions in excel 2013, date functions in excel 2007, date functions in access, ms excel date functions, to_date function, to_date function in oracle, date and time function in excel, the date function in excel, using date function in excel
Views: 54 Tutorials Bl3arabi
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: 884278 kudvenkat

32 mg iv zofran pulled from market
Wean off 60 mg prednisone daily
Eflagen 50 mg zoloft
Minocycline 100mg capsule acne medicine
Relpax 40 mg nebenwirkungen lyrica