USE OF LIKE OPERATOR IN SQL
USE OF LIKE OPERATOR IN SQL #sql #learnsql #sqlforbeginner #LIKEOPERATOR
WHAT IS THE USE OF LIKE OPERATOR IN SQL?
LIKE OPERATOR IS USED TO FETCH THE RECORDS BASED ON PATTERN MATCHING
EX : IF YOU WANT EMPLOYEES WHO ARE HAVING FIRST LETTER IN THE NAME SO WE USE LIKE OPERATOR
'A%' -- FIRST LETTER ''A''
'%A'--LAST LETTER ''A''
'____' -- FOUR CHARACTER NAME
'_A%' -- SECOND CHARACTER IS 'A'
'%A%'-- EMPLOYEES HAVING FIRST AND LAST CHARACTER AS ''A''
---------------------------------------------------------------------------------------------------------------------------
COMPLEX SQL QUERY PART 01 #COMPLEXQUERYINSQL #DISTINCTRECORDS #DELETE DUPLICATES
• COMPLEX SQL QUERY PART 01 #COMPLEXQUERYINS...
-----------------------------------------------------------------------------------------------------------------------
Fetch alternate records from Table using SQL Query #alternaterecords #learnsql #SQL
• Fetch alternate records from Table using S...
---------------------------------------------------------------------------------------------------------------------------
DECODE FUNCTION IN SQL #DECODEFUNCTIONINSQL #SQL #SQLFORBEGINNER
• DECODE FUNCTION IN SQL #DECODEFUNCTIONINSQ...
---------------------------------------------------------------------------------------------------------------------------
USES OF RANK AND DENSE_RANK FUNCTIONS IN SQL #SQL #RANKFUNCTIONS #DENSE_RANK #SQLBEGINNER.
• USES OF RANK AND DENSE_RANK FUNCTIONS IN S...
HOW TO EXTRACT NAMES FROM EMAIL ID BY "SUBSTR FUNCTION" ||SUBSTR FUNCTION|| SQL #SQL #SUBSTRFUNCTION
• HOW TO EXTRACT NAMES FROM EMAIL ID BY "SUB...
#SUBSTR
#sql
#LEARN SQL
EXTRACT NAMES,DOMAIN NAME,SERVICE PROVIDER NAME FROM SUBSTR FUNCTION.
#ORACLE DATABASE
SQL DDL COMMAND #SQL #LEARNSQL #ddl
• SQL CHARACTER FUNCTIONS #SQL #CHARACTERFUN...
SQL DML COMMAND #SQL #LEARNSQL #DML
• SQL DML COMMANDS #SQL #DMLCOMMANDS #INSERT...
SQL CHARACTER FUNCTIONS #SQL #CHARACTERFUNCTIONS #learnsql
• SQL CHARACTER FUNCTIONS #SQL #CHARACTERFUN...
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
THANK YOU FOR WATCHING!!!
PLEASE DO SUBSCRIBE FOR MORE UPDATES!!!