Тёмный
Coding Moments
Coding Moments
Coding Moments
Подписаться
Content on this channel are:-
1. Programming Videos and Lecture on Various Programming Languages.
2. Error solving problem.
3. Solution of Interviews Programming questions.
4. Interviews questions with their solutions.
5. Job Opening update in regular basis.
6. Latest update on technologies.

Education is the birthright of all.

Any kind of help you can contact on this email
codingmoments@gmail.com

Instagram:- instagram.com/rrk_726/
LinkedIn :- www.linkedin.com/in/iamramranjeetkuamr

Thankyou!
Intersect and Except Operator in SQL
20:36
8 месяцев назад
Комментарии
@PankajSingh0943
@PankajSingh0943 4 дня назад
Very informative and useful videos Sir
@codingmoments
@codingmoments 2 дня назад
Thanks and welcome
@tricksforsolving2804
@tricksforsolving2804 9 дней назад
good explanation
@sushil2596
@sushil2596 21 день назад
Hlloo please help me my spring file not connect with atlas
@koshtinimesh8247
@koshtinimesh8247 27 дней назад
join condition is a --- a condition merged two tables, join condition like a filter, condition present to get a valid records.
@koshtinimesh8247
@koshtinimesh8247 27 дней назад
join - merge two table with give condition
@koshtinimesh8247
@koshtinimesh8247 27 дней назад
ansi - american national standard institute
@koshtinimesh8247
@koshtinimesh8247 27 дней назад
Natural join
@koshtinimesh8247
@koshtinimesh8247 27 дней назад
JOIN - MERGE COLUMNS
@koshtinimesh8247
@koshtinimesh8247 27 дней назад
AMERICAN NATIONAL STANDARD INSTITUTE
@koshtinimesh8247
@koshtinimesh8247 27 дней назад
natural join
@koshtinimesh8247
@koshtinimesh8247 27 дней назад
AMERICAN NATIONAL STANDARD INSTITUTE
@koshtinimesh8247
@koshtinimesh8247 29 дней назад
confusion is max all video told you < less than , last 5 min change max sal use > so confusion. please check video
@koshtinimesh8247
@koshtinimesh8247 Месяц назад
ALL, ANY AND IN OPERATORS IS MULTI VALUED OPERATORS
@koshtinimesh8247
@koshtinimesh8247 Месяц назад
The inner query is executed first, and its results are then used to evaluate the outer query.
@koshtinimesh8247
@koshtinimesh8247 Месяц назад
OUTER QUERY IS DEFENDANT ON INNER QUERY, INNER QUERY IS INDEPENDENT
@koshtinimesh8247
@koshtinimesh8247 Месяц назад
CONCATENATION OPERATOR USE BY SELECT CLAUSE
@koshtinimesh8247
@koshtinimesh8247 Месяц назад
select clause - columnname,distinct,as,tablename,*
@koshtinimesh8247
@koshtinimesh8247 Месяц назад
from clause table name argument pass
@koshtinimesh8247
@koshtinimesh8247 Месяц назад
back ground sounds very irritating
@koshtinimesh8247
@koshtinimesh8247 Месяц назад
as with and without as
@koshtinimesh8247
@koshtinimesh8247 Месяц назад
FROM CLAUSE - FIND THE TABLE IN DATABASE AND PROVIDE TABLE IS UNDER EXECUTION MODE
@koshtinimesh8247
@koshtinimesh8247 Месяц назад
dql - select,selection, projection, joins
@koshtinimesh8247
@koshtinimesh8247 Месяц назад
RESULTANT COLUMN NAME CALLED A EXPRESSIONS
@koshtinimesh8247
@koshtinimesh8247 Месяц назад
SELECT CLAUSE FOR RESPONSIBLE FOR DISPLAY RESULTS'
@koshtinimesh8247
@koshtinimesh8247 Месяц назад
FROM CLAUSE RUN THEN TABLE GO TO THE UNDER EXECUTE MODE .
@koshtinimesh8247
@koshtinimesh8247 Месяц назад
CLAUSE ANOTHER NAME IS STATEMENTS
@koshtinimesh8247
@koshtinimesh8247 Месяц назад
PROJECTION CLAUSE
@koshtinimesh8247
@koshtinimesh8247 Месяц назад
FROM CLAUSE AFTER SELECT CLAUSE IS EXECUTE
@koshtinimesh8247
@koshtinimesh8247 Месяц назад
attribute
@koshtinimesh8247
@koshtinimesh8247 Месяц назад
F.k --- D.b multiple f.k., relationship between two tables, can have a null values,create a non- cluster index
@koshtinimesh8247
@koshtinimesh8247 Месяц назад
p.k --- d.b only one p.k,identify unique records,must have a value, create a cluster index
@koshtinimesh8247
@koshtinimesh8247 Месяц назад
Constrsint types- p.k,not null,unique key,foreign key, null
@koshtinimesh8247
@koshtinimesh8247 Месяц назад
u.k -- one or more than unique in table, can be a null value, easy to change , create a non cluster index , no supports auto increments,
@koshtinimesh8247
@koshtinimesh8247 Месяц назад
p.k --- table have one p.k ,cant accept null values, difficult to change, create a cluster index,auto increments supports
@koshtinimesh8247
@koshtinimesh8247 Месяц назад
cell is not null
@koshtinimesh8247
@koshtinimesh8247 Месяц назад
constraint types - unique constraint , Check constraint ,not null constraint, primery key constraint , foreign constraint
@koshtinimesh8247
@koshtinimesh8247 Месяц назад
table smallest parts cell
@koshtinimesh8247
@koshtinimesh8247 Месяц назад
Roll no int Data types
@koshtinimesh8247
@koshtinimesh8247 Месяц назад
char size >= 2000 , varchar size>=2000, varchar2 size =>4000
@koshtinimesh8247
@koshtinimesh8247 Месяц назад
studets is object
@koshtinimesh8247
@koshtinimesh8247 Месяц назад
query language - Manipulate Data from database | Sql - used to store,manipulate,retrieve data in relational databse.
@koshtinimesh8247
@koshtinimesh8247 Месяц назад
rdbms communicated - sql language
@koshtinimesh8247
@koshtinimesh8247 Месяц назад
dbms communicate - query language
@koshtinimesh8247
@koshtinimesh8247 Месяц назад
dbms provided features - security and authorization.
@kuunalrjumale8525
@kuunalrjumale8525 Месяц назад
bohot badiya explain kiya, thank u..
@koshtinimesh8247
@koshtinimesh8247 Месяц назад
where clause - filters records
@koshtinimesh8247
@koshtinimesh8247 Месяц назад
multi row function types - sum,max,min,count,avg
@koshtinimesh8247
@koshtinimesh8247 Месяц назад
MOD, SUBSTR,INSTR,TO_CHAR,TO_DATE FUNCTION VIDEOS
@koshtinimesh8247
@koshtinimesh8247 Месяц назад
GROUP FUNCTION AND AGGREGATE FUNCTIONS
@sikandar5242
@sikandar5242 Месяц назад
I am the 1st one who came so far to this series