Lec-71: 3 Imp Questions on SQL basic Concepts | DBMS

[@kushalsharma0074]

If in future anyone asked me "Resources to learn SQL and DBMS " ... undoubtedly I will recommend your videos

[@sid_idea7250]

Not only SQL and DBMS, this channel is full package of CSE....a great channel for CSE students

[@ahmad.2215]

You are one of a kind. We wasted 4 years in university but not a single teacher teach any subject like you do and for all your subjects. Bro, you are the Greatest Channel for Asian CS students. Live Long Man.

[@sid_idea7250]

Absolutely 👍

[@483_saurabhjindal6]

He is my.hope in my IT career . He makes concept very easy . #What a Teacher

[@aayush4040]

@@483_saurabhjindal6kiski preparations krrhe ho bhai?

[@vaisnavichirag]

Note: MS Access uses an asterisk (*) instead of the percent sign (%), and a question mark (?) instead of the underscore (_).

[@darshillashkari6384]

you are the best you are pointing out small details in sql which is very facinating

[@ajay_t_47]

You're one of the best teacher I've ever seen in my career...... Bless you sir ji...🙌🏼

[@BipinKumar-jq8ks]

You are a great teacher of SQL.

[@charimahender2896]

Good video's and good explanation 🎉🎉🎉🎉🎉🎉

[@ovazsardar1458]

sir g lov u khush rahen ... good teacher

[@K_EC_AushoRoup]

In question 3, Sir, There shouldn't be the same tuples in a table in general. So, Q1, Q2 and Q3 all queries should give the same output.

[@celestial2091]

because primary key will be different for all right??

[@rahulshingne1963]

Are you correct?😅

[@abhimanyusoni491]

I was about to say this,

[@gauravpatil429]

Sir, you create concepts which we can easily learn. You are great sir 🙂

[@medepallipadmini1140]

Thank you sir for explanation videos

[@rohitdwivedi5851]

Wonderful explanation

[@harshdeosingh6765]

One of the best explaination for ever

[@divyakeshri2831]

BEST BEST BEST THANKU FOR THIS AMAZING COURSE SIR❤

[@krishanudutta2943]

Thanks for such quesitions and for a great lecture

[@karanmalkhede6689]

Best explanation sir

[@AmanJoshiShinigami]

Question 3 might have different answer in different scenarios

[@raviprakashgupta9641]

5:30 delete table command hoti hai na sir isse stuctue ko kuch nahi hota par us attribute ki sari values clear ho jati hai aap ne hi aapni ek lecture me padhata tha

[@rahulshingne1963]

Ha hoti hai delete command sir ne padhaya tha lekin delete command se bas rows clear hoti hai table ka schema change nahi hota

[@animationcrust1993]

Gained new knowledge ☺️♥️

[@PythonisLove]

Thanks for such efforts, you are literally making future for millions of Indian students...

[@mayankjoshi103]

How millions of students? Only 69K views are there for this vdo..

[@PythonisLove]

@@mayankjoshi103 and it'll increase everyday

[@Messi-nz9od]

@@mayankjoshi103 Total views of this channel are 185 million.

[@vivekraj6483]

Sir great explanation

[@patilsoham]

Thanks for the explanation. Efforts appreciated sir.

[@harshalpatil6482]

Thanks sir ji ☺️❤️🙏🏻

[@mahikumar7759]

5:29 sr delete table command hoti to h or aapne delet ,drop,truncate me difference bhi btaya h🙄

[@Hihihi190]

Thank you ❤

[@simasingh5587]

thanx u sir, toc ke grammer and language based question ki pratice kra do.

[@ShaliniSingh-xc5rn]

Thank u sir 🙏

[@softmedun6794]

Great sir

[@jayadevmandal4323]

Nice explanation sir

[@AbhiShek.PandwaR]

_ is for one character, % is for string or no of characters, But whats the purpose of *(star) ?? Or it's just as option.

[@vaisnavichirag]

Note: MS Access uses an asterisk (*) instead of the percent sign (%), and a question mark (?) instead of the underscore (_).

[@manjuvimal8114]

superb sir

[@happycoding5163]

best explaination....

[@sukhpalkaur2415]

Thnku so much sir

[@MadhuriKishorr]

Thanks You👍

[@vishnus1711]

Nice brother usefull

[@arpitgarg4756]

Hi Varun, you are doing good but I have one concern that is, I want to know how can we delete duplicate records from the table ? Most of the interviewers ask this question?

[@satishshah3861]

Delete from R where id in (Select id from (Select id , row_number() over (partition by X order by X) as rowno from table R) as temp_tab where rowno > 1);

[@amarks444]

@Gate Smashers In Q.3 are we assuming that there are no primary key? Because if any of a , b is primary key than answer could be different ?

[@prakhargupta5720]

no, if they are primary key then there will be no duplicate value brother.

[@deepshikhatiwary37]

best explanation

[@akshaythorat3133]

Please make vedieo any and all command in sql

[@kodumude]

Sir..in first question..4 th option*A%. ..need explanation on that

[@minakshi_119]

bow down to hero.......

[@anshukumar3928]

sir , ek doubt hai, Aapne bola ki relation me koi tuple repeat ho rhi to distict uss repeated tuple ko bas ek baar dikhayega. Magar ek table me koi tuple dobaar kyu mentioned hoga considering ki primary key unique hote hai?

[@AdityaGupta-fz8mr]

same doubt bro...did u get your ans?? please tell us if u do

[@noorulain8463]

sometimes it happens when beginners start working.. they can make such type of mistakes.

[@khushalsahni6058]

Are bhai maanle salary select ki kisi table ki toh wo unique na hogi na, us pe operation agar karenge toh ye case hoga

[@rahulshingne1963]

@@khushalsahni6058 attributes ke liye duplicates ho sakte hai lekin questions me tuples pucha hai

[@namratanikam7566]

Great😊😊

[@richenjoshi7054]

The answer to 3rd question is wrong. There are two columns: a and b. Due to constraints, tuples are not allowed to be repeated. Therefore, every tuple is distinct, and intersection of same two tables will always be same as the original table. Hence, the answer is a.

[@kiransingparadeshi2196]

where R(a,b) is used than?

[@LearnerForever123]

The example you just took cannot be possible as it violates the property that Primary Key should be different. In that case, Q1 and Q2 will always give the same output.

[@A_S_D_gaming-c]

Thank you sir

[@Official-tk3nc]

COMMENT YOUR COLLEGE NAME ; LETS TELL YOUR JUNIORS THAT YOU EXIST

[@ItsAbhiDestiny]

Delete koi command nhi hoti ???

[@explorethevogue8242]

thankyou 👍

[@jiyaahuja7539]

Sir * n % m Kya difference h...dono any number of characters deta h kya

[@saitejagampala7222]

* is used in MS Access and % is used in SQL Server.... Dono zero or more characters ko represent karte hai

[@shambhvisharma8164]

Query to display the name whose middle letter is given????

[@payalsagar1808]

sir intersect yaani query 2 k case me 1233 output ana chahiye na because, intersect operator to duplicacy nhi htata na?

[@abhisekchowdhury8584]

"Intersect" removes duplicate rows whereas, "Intersect All" retains the duplicate ones.

[@abhisekchowdhury8584]

"Union" also removes duplicate rows

[@praffulchaturvedi435]

@@abhisekchowdhury8584Thanks :)

[@krishankant8480]

3 rd questio n dubara dekho intersecton hai na ki unioun

[@RP-mq4ts]

What does * specifies in options of Q(1) ?

[@jiteshkumar3112]

means all no. of rows and column will be printed

[@anusrutimitra1115]

All rows n columns

[@sauravVocals]

He means " *A%"

[@N__VaradUplanchiwar]

Sir in Question 3, would'nt the intersect query give result as 1,2,3,3 as it is common in both tables?? It should not give unique result right?

[@LearnerForever123]

i think for that we use INTERSECT ALL. not sure though

[@N__VaradUplanchiwar]

Okayy

[@oshniklife9661]

Wooooooooooow

[@samychakraborty4989]

thnq sir

[@anshujindal3694]

There is always a primary key in a table, so by that logic q1 and q3 produce same result

[@ssc_-kn6os]

No we can make a table in SQL without any primary key as well

[@sunilkumar-ft3nk]

Attribute b can also act as a primary key

[@Jaiprakashchahar]

sir ji prso exam hai mera kal to ghr jana hai vhan net nhi chlta sirf aaj ka time hai aap plz 10-15 question gate k jo most important hein vo kra dijiye plz it's a request...

[@shreyanshsaxena8387]

In your service Brh;)

[@Atul_Agnihotri]

In ques. 1 option are diff which you describe and which given option '%A_' and '_A%' both similar or not ??

[@locus2468]

both are different

[@shimpygoyal8311]

Am getting confused as delete command to remove only relations not full structure then y said delete not exist??

[@harshshah9962]

delete is used to remove tuples not relations. Re-watch lec-53.

[@karmveersingh1334]

We use delete from table_name.. And not direct..delete table_name

[@jitendergupta2240]

sir, agar mai use karu union instead of intersect to output kya aaengaa??

[@elisadevid5660]

I think then Q1 Q2 will produce same result

[@ranveeryadav3456]

Sir, let say we have to preserve position of 'A' in 10000th place, then should we write "_" 9999 times ??, It is not good idea I think, is there any bettar approch for this??

[@AbhishekA-81]

No one will require such queries first of all and if required such queries will be fetched and executed in seperate coding environment in Java or CPP rather than processing data in MySQL.

[@sambalryder]

in question 3,can i take two columns like a and b ?

[@noorulain8463]

yes

[@waqarahmad2752]

👍

[@arnobchowdhury1804]

heres one way : SELECT TOP 1 salary FROM( SELECT TOP 3 salary FROM EMP ORDER BY DESC) ORDER BY AESC;

[@gabbarsingh6562]

3rd question dekh lena

[@kirtigumber7782]

Done

[@mandalaquotes_arts9919]

Q3:i guess option b is correct

[@noorulain8463]

no c is correct bcz distinct and intersect both have same properties

[@anusrutimitra1115]

Fan😬

[@viralvideoa]

Thankyou sir

[@oshniklife9661]

1st

[@optimusnafri480]

[@pujasumanthytripathy5366]

Thank u sir🙏

[@suchetabhatia4473]

Thanku so much sir

[@divyaagarwal3091]

Thankyou Sir

[@varshaelf]

Thank you sir

[@sratnamanjari244]

Thank You Sir