ISNULL (SQL Server) NVL (Oracle) SQL In 2 Mins Video 2
DROP TABLE IF EXISTS tblEmployee_Demo
CREATE TABLE tblEmployee_Demo(ID INT,
Name Varchar(20),
Location_1 Varchar(20),
Location_2 Varchar(20)
)
INSERT tblEmployee_Demo VALUES (1,'Smith','Newyork', 'London')
INSERT tblEmployee_Demo VALUES (2,'Peter','Australia', NULL)
INSERT tblEmployee_Demo VALUES (3,'David',NULL, 'Canada')
INSERT tblEmployee_Demo VALUES (4,'George',NULL,'Japan')
-- 2. ISNULL -- SQL Server
-- NVL -- ORACLE
-- Its replaces NULL Value with more meaningful alternative in the result
SELECT * FROM tblEmployee_Demo
SELECT ID, Name, ISNULL(Location_1,Location_2) AS Location_1, ISNULL(Location_2, Location_1) AS Location_2
FROM tblEmployee_Demo
-------------------------
This channel would provide new videos on SQL, ETL and Data warehouse concepts. I would create a separate play list for SQL Tutorials for beginners, advanced concepts, Interview questions and data warehousing concepts
Feel free to drop me an email at [email protected] in case of any queries you have in SQL or clarifications on the videos I have done :)
Please like my facebook page:
Facebook page: / sql.ravimartha.5
Blog: https://sqlwithravimartha.blogspot.co...
Video 12: Import Tables from one Server to another Using SSMS | Import tables using SQL Query in SSMS --* • Import Tables from one Server to anot...
Blog: https://sqlwithravimartha.blogspot.co...
Video 11: Table Variables in SQL Server | Pound Tables | Table Variable in SQL | Table Variable in Tempdb --* • Table Variables in SQL Server | Pound...
Blog: https://sqlwithravimartha.blogspot.co...
Video 10: Quick Practical onTemporary tables in SQL Server | Temp Tables in SQL | Local Temp Table | Global Temp Table--* • Quick Practical on Temporary tables i...
Blog: https://sqlwithravimartha.blogspot.co...
Video 9: Temporary tables in SQL Server | Temp Tables in SQL | Local Temp Table | Global Temp Table -- * • Temporary tables in SQL Server | Temp...
Blog: https://sqlwithravimartha.blogspot.co...
Video 8: Running total & Avg in SQL | Cumulative Sum & Avg in SQL | Calculating running total & Avg in SQL -- * • Running total & Avg in SQL | Cumulati...
https://sqlwithravimartha.blogspot.co...
Video 7 Title: Length Vs DataLength Vs ColumnLength | Len() | DataLength() | Col_Length | Column length in SQL -- * • Length Vs DataLength Vs ColumnLength ...
https://sqlwithravimartha.blogspot.co...
Video 6 Title: Tricky CASE Statement Interview Questions | CASE WHEN | WHEN Clause | CASE Statement in SQL -- * • Tricky CASE Statement Interview Quest...
https://sqlwithravimartha.blogspot.co...
Video 5 Title: Delete Duplicates in SQL by retaining one Unique record | Row Duplicates | Business Key Duplicates -- * • Delete Duplicates in SQL by retaining...
https://sqlwithravimartha.blogspot.co...
Video 4 Title: Difference between TRUNCATE, DELETE and DROP -- * • Difference between TRUNCATE, DELETE a...
https://sqlwithravimartha.blogspot.co...
Video 3 Title: Sorting in SQL | Order By | Conditional Sorting| Unusual Sorting -- * • Sorting in SQL | Order By | Condition...
https://sqlwithravimartha.blogspot.co...
Video 2 Title: Difference between Primary Key and Unique Key -- * • Difference between Primary Key and Un...
https://sqlwithravimartha.blogspot.co...
Video 1 Title: Logical Processing of SELECT Statement -- * • Logical Processing of SELECT Statemen...
https://sqlwithravimartha.blogspot.co...
Blog: https://sqlwithravimartha.blogspot.com/
Facebook Page:
/ sql-with-ravimartha-109497027391239
/ etl-dwh-testing-100494175057349
Youtube Channel:
/ @sqlwithravimartha6357
Смотрите видео ISNULL (SQL Server) NVL (Oracle) SQL In 2 Mins Video 2 онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь SQL With RaviMartha 08 Декабрь 2020, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 21 раз и оно понравилось людям.