Tap to unmute

Part1: SQL Query Interview Questions & Answers

  Рет қаралды 272,067

SDET- QA

SDET- QA

Күн бұрын

Пікірлер: 107
@MoizAnsari-jb2im
@MoizAnsari-jb2im 9 ай бұрын
Thank you so much sir for sharing helpful videos
@sdetpavan
@sdetpavan 9 ай бұрын
Most welcome
@samratjulme8418
@samratjulme8418 2 жыл бұрын
very helpful........thank you for uploading...............
@sdetpavan
@sdetpavan 2 жыл бұрын
Most welcome
@cuitlahuaccorona5122
@cuitlahuaccorona5122 2 жыл бұрын
Hi sir, I would like to thank to you for the knowledge that you share. I am understanding many concepts. Greetings from México.
@KarthickKings143
@KarthickKings143 3 жыл бұрын
Employee Table: create table employee(Empid int, name varchar(10), ManagerId int, DOJ date, city varchar(10)); insert into employee values(121, 'John', 321, '2016-01-31', 'Hyd'); insert into employee values(321, 'David', 986, '2018-01-30', 'Chennai'); insert into employee values(421, 'Scott', 876, '2020-11-27', 'Mumbai');
@ncasmeer1
@ncasmeer1 2 жыл бұрын
3rd question also can write select count(EmpId) from salary where project='p1';
@shashb3194
@shashb3194 8 ай бұрын
Sir it’s very helpful thank you so much sir
@sdetpavan
@sdetpavan 8 ай бұрын
Most welcome
@debiprasaddash3077
@debiprasaddash3077 3 жыл бұрын
you are doing a great job sir
@dharma2790
@dharma2790 3 жыл бұрын
Thank you so much sir. 10 days before I started learning SQL from your channel sir.
@chinnappareddy9115
@chinnappareddy9115 3 жыл бұрын
Thank sir your encourage ment
@venkateshvenki7552
@venkateshvenki7552 2 жыл бұрын
Hello Hai bro u got this sql job bro.?
@surajpatil3579
@surajpatil3579 3 жыл бұрын
Thanks sir.. waiting 4 next part
@VijayRaman-m2m
@VijayRaman-m2m Жыл бұрын
Nice and useful video
@sdetpavan
@sdetpavan Жыл бұрын
Thanks
@svetlanamazhaykina6918
@svetlanamazhaykina6918 3 жыл бұрын
Thank you and keep up the good work.
@AnuRadha-nz7nx
@AnuRadha-nz7nx 3 жыл бұрын
Thanks a lot sir for making video on sql interview questions
@vincyantony4274
@vincyantony4274 3 жыл бұрын
Thanks a lot sir . All your videos are very useful.
@akdvlog
@akdvlog 2 жыл бұрын
Very easy questions.
@shalinigajjela1249
@shalinigajjela1249 6 ай бұрын
Thank you so much for understanding the concepts
@sdetpavan
@sdetpavan 5 ай бұрын
Welcome
@WilsonTandeka
@WilsonTandeka 6 ай бұрын
Wow this is so helpful, thank you so much!
@sdetpavan
@sdetpavan 6 ай бұрын
Welcome
@siyaramsingh4986
@siyaramsingh4986 3 жыл бұрын
Thanx a lot for these wonderful sessions.
@sdetpavan
@sdetpavan 3 жыл бұрын
Most welcome!
@sushkak
@sushkak 3 жыл бұрын
Thank you sir. Please do Java interview questions also.🙏
@prashantkandarkar8993
@prashantkandarkar8993 3 жыл бұрын
Yes guys please comments all of you for starting java interview questions sk that sir can make video on that
@smithabhat7022
@smithabhat7022 5 ай бұрын
Very useful
@sdetpavan
@sdetpavan 5 ай бұрын
Thanks
@divyadubey6679
@divyadubey6679 2 жыл бұрын
Thank u so much sir for this video
@sdetpavan
@sdetpavan 2 жыл бұрын
Most welcome
@karthikviswanath2795
@karthikviswanath2795 3 жыл бұрын
easily understandable.
@sdetpavan
@sdetpavan 2 жыл бұрын
Thanks
@javashashavali
@javashashavali Жыл бұрын
Thanks you sir
@sdetpavan
@sdetpavan Жыл бұрын
Welcome
@akashjanrao2713
@akashjanrao2713 2 жыл бұрын
Thanks lot sir ,
@sdetpavan
@sdetpavan 2 жыл бұрын
welcome
@anokhighatna009
@anokhighatna009 2 жыл бұрын
You are great
@sdetpavan
@sdetpavan 2 жыл бұрын
thanks
@jagadeeshkumar9745
@jagadeeshkumar9745 3 жыл бұрын
You make our life easy. Thanks a lot🙏
@pavelpatriots8802
@pavelpatriots8802 2 жыл бұрын
Big thanks from Russia
@sdetpavan
@sdetpavan 2 жыл бұрын
You’re welcome
@KarthickKings143
@KarthickKings143 3 жыл бұрын
Salary Table: create table salary(Empid int, Project varchar(10), salary int, variable int); insert into salary values (121, 'P1', 20000, 0); insert into salary values (321, 'P2', 35000, 1000); insert into salary values (421, 'P1', 50000, 3000);
@chandumit1259
@chandumit1259 Жыл бұрын
what is the datatype we should use for p1,p2,p3 because for p1 we have varchar and integer right
@andrewgray2632
@andrewgray2632 2 жыл бұрын
Good stuff my man - keep doing your thing homie! This stuff helps greatly!!
@sandeepreddyvulavala2816
@sandeepreddyvulavala2816 3 жыл бұрын
Thank you
@satishkumarg7403
@satishkumarg7403 3 жыл бұрын
thank you so much sir
@jobisha6704
@jobisha6704 2 жыл бұрын
Really a helpful session! Thanks for this video! :)
@sdetpavan
@sdetpavan 2 жыл бұрын
Welcome
@PushpaKumari-dv1pr
@PushpaKumari-dv1pr Жыл бұрын
thanks a lot sir
@sdetpavan
@sdetpavan Жыл бұрын
Most welcome
@harishankar5455
@harishankar5455 3 жыл бұрын
question 3. select count(empid) as employeecount from salary where project ='p1' so is this correct sir?
@vaibhavshinde63
@vaibhavshinde63 3 жыл бұрын
Please do a fresh series on Java interview questions as well. Thanks.
@sdetpavan
@sdetpavan 3 жыл бұрын
Sure
@DerexArchives
@DerexArchives Жыл бұрын
for 8:27 do you need to select all 3 fields or just the EmpId?
@kingsheruyt8803
@kingsheruyt8803 3 жыл бұрын
Thank you sir , please make videos for cloud testing
@vijaybhaskarravipati580
@vijaybhaskarravipati580 3 жыл бұрын
Please do video on manual testing sir it help us lot sir
@ShortsFromPlaylist
@ShortsFromPlaylist 2 жыл бұрын
Thank you sir
@sdetpavan
@sdetpavan 2 жыл бұрын
Welcome
@ashwinijadhav7438
@ashwinijadhav7438 3 жыл бұрын
Pavan Sir please make a vedio on tcp ip protocol and network testing
@shravank8931
@shravank8931 2 жыл бұрын
Sir in question number 8. If i write SELECT DISTICT FROM salary where NOT Project='P1'; Like this then it is correct or not.?
@aarunkumar
@aarunkumar 3 жыл бұрын
Sir please explain about Serenity bdd framework
@vaddesurendra1542
@vaddesurendra1542 Жыл бұрын
Sir did you post the any SQL database videos in basic version
@harishakula238
@harishakula238 3 жыл бұрын
Sir please do java interview questuons...
@priyankalanda8921
@priyankalanda8921 3 жыл бұрын
Sir will u provide online classes for selenium??
@terryterry3733
@terryterry3733 3 жыл бұрын
😍
@sureshkumar-es6xy
@sureshkumar-es6xy 2 жыл бұрын
Hi sir We need more videos, please update in KZbin
@shravanikumar902
@shravanikumar902 2 жыл бұрын
Movie table CREATE TABLE "MOVIE" ( "Id" int(11) NOT NULL DEFAULTS "0", "name" VARCHAR (100) DEFAULTNULL "year" int(11) DEFAULT NULL "rank" float DEFAULT NULL PRIMARY KEY "Id" Considering the above table. How many movies does the dateset have for the year ? Write a ur query below...........
@deveshpadgelwar8895
@deveshpadgelwar8895 2 жыл бұрын
Thank you Sir.. But now day Interviewer asking most of SQL complex queries... Please do some videos on complex queries.... Thank you Again Pavan sir
@nagesh.p
@nagesh.p 2 жыл бұрын
Please post interview questions on experience post on pl/sql
@prathameshshelake6045
@prathameshshelake6045 Жыл бұрын
Thans
@venkateshvenki7552
@venkateshvenki7552 2 жыл бұрын
Hello gdevng sir actually which is best course in software like with out programming sir devops sql etc please reply me sir
@anshuljain216
@anshuljain216 Жыл бұрын
Hello sir, is there any paid classes for Autometion testing?
@collegematerial5348
@collegematerial5348 Жыл бұрын
is this series help for interview preaparation
@sekharreddy3236
@sekharreddy3236 3 жыл бұрын
Hi Pawan, its a very useful session, thanks a lot this this video. Can you please do the same for Java, Selenium as well please (based on your available time)
@pratibhajain923
@pratibhajain923 Жыл бұрын
Hello sir , do u have udemy course for Sql
@sunilrenati2803
@sunilrenati2803 2 жыл бұрын
hello sir where do i get this ppt?
@niacheishvili1908
@niacheishvili1908 2 жыл бұрын
Hi, could you please tell me what will be the SQL command in case I want the last 10 rows from the column ? Thanks in advance !!
@livetoexplore5527
@livetoexplore5527 Жыл бұрын
You can use Salary Desc Limit 10
@sunilmadgi4234
@sunilmadgi4234 2 жыл бұрын
i have 3 tables 01) table employee (columns are empid,empname , depid) 02) table Department ( columns are depid, dep name) 03) table salary (columns are empid,amount,month). Q) get the empname , how don't get the salary in the month of December please let me know the ans for this questions ,its my request
@ravikaanth8140
@ravikaanth8140 2 жыл бұрын
SELECT EMPNAME FROM EMPLOYEE WHERE EMPID IN (SELECT EMPID FROM SALARY WHERE AMOUNT IS NULL AND MONTH IN 'DEC');
@saiprasanthpk17
@saiprasanthpk17 Жыл бұрын
Hi Pavan sir your explanation is superb!! But I don't get exact diff of distinct and group by
@குரு-த6ய
@குரு-த6ய 10 ай бұрын
Distinct fetches unique values, Group by groups by any columns.
@PenumudiRamya-o6x
@PenumudiRamya-o6x 10 ай бұрын
Could you please share this questions and answers in ppt sir
@sanketmeshram2289
@sanketmeshram2289 2 жыл бұрын
Sir, I want a sample hr database for practice please help me for the same. i'm not getting it on your websites.
@Visit_America
@Visit_America 2 жыл бұрын
THE LAST DATE FORMATE IS INCORRECT WHERE EMPID IS 421
@dilipraskar9271
@dilipraskar9271 Жыл бұрын
SQL practice sathi konte best platform ahet.... please reply
@aparnabiswas1180
@aparnabiswas1180 3 жыл бұрын
Hi Sir, If I join the channel by clicking in JOIN button, can I get one to one class from you?
@DeepakSah3.0
@DeepakSah3.0 2 жыл бұрын
No
@aishwaryashubhalaxmi5877
@aishwaryashubhalaxmi5877 3 жыл бұрын
Sir, how many videos will be there in total as a part of this series?
@aishwaryaphadale7624
@aishwaryaphadale7624 10 ай бұрын
Hello Sir , Where we can get sql notes ?
@vasantvarma6406
@vasantvarma6406 2 жыл бұрын
It should be Select Distinct Project from Salary and not Distinct (Project). Some times it can give rejection in interview
@troglodita666
@troglodita666 Жыл бұрын
too much mic blow, I can't stand it
@divyakerekar8971
@divyakerekar8971 2 жыл бұрын
What is the difference between mssql and sql
@dailyenglishstructure2137
@dailyenglishstructure2137 3 жыл бұрын
Sir please upload on mechanical diploma students please sir
@kavyakamineni2198
@kavyakamineni2198 2 жыл бұрын
Hi Pavan, As said at your website, we have paid 21999 rs for QA Oct 6th batch classes. I have already sent mail where the payment details attached to the concern mail. We havent got any update or payment received confirmation mail or any sought of concern. We have even tried if we can get any contact but couldnt succeed. How should we approach you and make sure about our slot with bacth or How we will be knowing about the payment confirmation. Kindly please let us know at your earliest convenience.
@mahesh1724
@mahesh1724 2 жыл бұрын
Hi sir .. I completed M -Tech in MECHANICAL ENGINEERING.. & Working as a Asst Professor in Enginnering college since from last 10 years .. But now I want to switch in to IT field .. NOW I am learning SQL in KZbin only ... Is there any chance of getting job into IT field.. please suggest me sir.. Waiting for your reply sir...
@mayurtandel1837
@mayurtandel1837 2 жыл бұрын
plz provide pdf of all this questions
@bhanuprakashkandhadi9129
@bhanuprakashkandhadi9129 2 жыл бұрын
Hi Pavan Sir, I am Learning manual testing and automation testing from ur channel. But SQL is important for testers. I am in a bit confusion to learn which SQL first. In Your channel there is mysql. Is that enough for testers
@loveroflight7797
@loveroflight7797 2 жыл бұрын
Any sql is fine .. there are almost similar veery slight difference. . So. If you learn. One you can do other sql aswell
@satyanarayanamurthyyerrapr4069
@satyanarayanamurthyyerrapr4069 3 жыл бұрын
Sir, I'm looking out for training on ETL testing, May I know contact number to discuss and join the course.. Thank you
@infinitium3863
@infinitium3863 2 жыл бұрын
Your recent videos have very low volume. Very hard to hear.
@rockstar1195
@rockstar1195 2 жыл бұрын
Thank you
@sdetpavan
@sdetpavan 2 жыл бұрын
You're welcome
Part2: SQL Query Interview Questions & Answers
26:13
SDET- QA
Рет қаралды 113 М.
Quilt Challenge, No Skills, Just Luck#Funnyfamily #Partygames #Funny
00:32
Family Games Media
Рет қаралды 55 МЛН
人是不能做到吗?#火影忍者 #家人  #佐助
00:20
火影忍者一家
Рет қаралды 20 МЛН
Enceinte et en Bazard: Les Chroniques du Nettoyage ! 🚽✨
00:21
Two More French
Рет қаралды 42 МЛН
The 25 SQL Questions You MUST Know for Data Analyst Interviews
32:47
KSR Datavizon
Рет қаралды 251 М.
Top 15 SQL Interview Questions and Answers for Software Testing professionals || Part-A
26:10
Software Testing And Automation
Рет қаралды 82 М.
Quilt Challenge, No Skills, Just Luck#Funnyfamily #Partygames #Funny
00:32
Family Games Media
Рет қаралды 55 МЛН