00:04 Introduction about the candidate 01:04 PCL commands in SQL commands 01:46 Difference between WHERE and HAVING clause 02:24 Difference between DROP, DELETE, and TRUNCATE 03:13 Deletion and constraints in SQL 03:58 Aggregate functions in SQL are used to perform operations on groups of values. 04:47 The nullif function in SQL returns null if two expressions are equal, otherwise it returns the first expression. 05:34 Writing SQL queries for specific time periods and fetching tables from database.
Delete does not comes under DDL it comes under DML DDL-create,alter,rename, truncate, drop. DML- Select,insert, update, delete DCL- Grant and revoke TCL- Commit, rollback, save checkpoint Constrains- not null,keys(primary, foreign, candidate), checks.
00:04 Introduction about the candidate
01:04 PCL commands in SQL commands
01:46 Difference between WHERE and HAVING clause
02:24 Difference between DROP, DELETE, and TRUNCATE
03:13 Deletion and constraints in SQL
03:58 Aggregate functions in SQL are used to perform operations on groups of values.
04:47 The nullif function in SQL returns null if two expressions are equal, otherwise it returns the first expression.
05:34 Writing SQL queries for specific time periods and fetching tables from database.
Delete does not comes under DDL it comes under DML
DDL-create,alter,rename, truncate, drop.
DML- Select,insert, update, delete
DCL- Grant and revoke
TCL- Commit, rollback, save checkpoint
Constrains- not null,keys(primary, foreign, candidate), checks.
Savepoint
Purge in ddl
@hardiknaik9124 in alter only we have rename 🧐bro
delete is not sql command
This aspirant is rocking..well done man...All the best...
Delete comes under DML
How does that last code fetch all the tables from a database!?
Doesn't that just prints table_name under user table!!
Show tables;
Keep going.
Like this company ❤
Nice Dinesh bro
keep going
Nice 👍
Is this MySQL or any other becoz i didn't learn these months_between , to_char functions in MySQL
Oracle sql
@@Software-Banyan3 oh thankyou
Actually I have technical round today on MySQL u saved me.
Nice
Good job
nice
Super duper HR
😂😅
😆😆 4:45
Can anyone tell how to get job in sql for freshers in delhi
Means
Bhai laal kila dekh lena akshardham dekh lena lotus temple fir mil jayegi sql me 😂😂😂
I'm from Nellore
Iam also from narayana Engineering College background
Very confusing man😂😂
3:27 sql😂
Nice answers 😂😂😂😂
😂😂
He was right the interviewers question was wrong😂😂😂
It's under DML data manipulation language
nothing but nothing but nothing but........
Nice
Nice Dinesh