what is the datatype we should use for p1,p2,p3 because for p1 we have varchar and integer right
@andrewgray26322 жыл бұрын
Good stuff my man - keep doing your thing homie! This stuff helps greatly!!
@sandeepreddyvulavala28163 жыл бұрын
Thank you
@satishkumarg74033 жыл бұрын
thank you so much sir
@jobisha67042 жыл бұрын
Really a helpful session! Thanks for this video! :)
@sdetpavan2 жыл бұрын
Welcome
@PushpaKumari-dv1pr Жыл бұрын
thanks a lot sir
@sdetpavan Жыл бұрын
Most welcome
@harishankar54553 жыл бұрын
question 3. select count(empid) as employeecount from salary where project ='p1' so is this correct sir?
@vaibhavshinde633 жыл бұрын
Please do a fresh series on Java interview questions as well. Thanks.
@sdetpavan3 жыл бұрын
Sure
@DerexArchives Жыл бұрын
for 8:27 do you need to select all 3 fields or just the EmpId?
@kingsheruyt88033 жыл бұрын
Thank you sir , please make videos for cloud testing
@vijaybhaskarravipati5803 жыл бұрын
Please do video on manual testing sir it help us lot sir
@ShortsFromPlaylist2 жыл бұрын
Thank you sir
@sdetpavan2 жыл бұрын
Welcome
@ashwinijadhav74383 жыл бұрын
Pavan Sir please make a vedio on tcp ip protocol and network testing
@shravank89312 жыл бұрын
Sir in question number 8. If i write SELECT DISTICT FROM salary where NOT Project='P1'; Like this then it is correct or not.?
@aarunkumar3 жыл бұрын
Sir please explain about Serenity bdd framework
@vaddesurendra1542 Жыл бұрын
Sir did you post the any SQL database videos in basic version
@harishakula2383 жыл бұрын
Sir please do java interview questuons...
@priyankalanda89213 жыл бұрын
Sir will u provide online classes for selenium??
@terryterry37333 жыл бұрын
😍
@sureshkumar-es6xy2 жыл бұрын
Hi sir We need more videos, please update in KZbin
@shravanikumar9022 жыл бұрын
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...........
@deveshpadgelwar88952 жыл бұрын
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.p2 жыл бұрын
Please post interview questions on experience post on pl/sql
@prathameshshelake6045 Жыл бұрын
Thans
@venkateshvenki75522 жыл бұрын
Hello gdevng sir actually which is best course in software like with out programming sir devops sql etc please reply me sir
@anshuljain216 Жыл бұрын
Hello sir, is there any paid classes for Autometion testing?
@collegematerial5348 Жыл бұрын
is this series help for interview preaparation
@sekharreddy32363 жыл бұрын
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 Жыл бұрын
Hello sir , do u have udemy course for Sql
@sunilrenati28032 жыл бұрын
hello sir where do i get this ppt?
@niacheishvili19082 жыл бұрын
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 Жыл бұрын
You can use Salary Desc Limit 10
@sunilmadgi42342 жыл бұрын
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
@ravikaanth81402 жыл бұрын
SELECT EMPNAME FROM EMPLOYEE WHERE EMPID IN (SELECT EMPID FROM SALARY WHERE AMOUNT IS NULL AND MONTH IN 'DEC');
@saiprasanthpk17 Жыл бұрын
Hi Pavan sir your explanation is superb!! But I don't get exact diff of distinct and group by
@குரு-த6ய10 ай бұрын
Distinct fetches unique values, Group by groups by any columns.
@PenumudiRamya-o6x10 ай бұрын
Could you please share this questions and answers in ppt sir
@sanketmeshram22892 жыл бұрын
Sir, I want a sample hr database for practice please help me for the same. i'm not getting it on your websites.
@Visit_America2 жыл бұрын
THE LAST DATE FORMATE IS INCORRECT WHERE EMPID IS 421
@dilipraskar9271 Жыл бұрын
SQL practice sathi konte best platform ahet.... please reply
@aparnabiswas11803 жыл бұрын
Hi Sir, If I join the channel by clicking in JOIN button, can I get one to one class from you?
@DeepakSah3.02 жыл бұрын
No
@aishwaryashubhalaxmi58773 жыл бұрын
Sir, how many videos will be there in total as a part of this series?
@aishwaryaphadale762410 ай бұрын
Hello Sir , Where we can get sql notes ?
@vasantvarma64062 жыл бұрын
It should be Select Distinct Project from Salary and not Distinct (Project). Some times it can give rejection in interview
@troglodita666 Жыл бұрын
too much mic blow, I can't stand it
@divyakerekar89712 жыл бұрын
What is the difference between mssql and sql
@dailyenglishstructure21373 жыл бұрын
Sir please upload on mechanical diploma students please sir
@kavyakamineni21982 жыл бұрын
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.
@mahesh17242 жыл бұрын
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...
@mayurtandel18372 жыл бұрын
plz provide pdf of all this questions
@bhanuprakashkandhadi91292 жыл бұрын
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
@loveroflight77972 жыл бұрын
Any sql is fine .. there are almost similar veery slight difference. . So. If you learn. One you can do other sql aswell
@satyanarayanamurthyyerrapr40693 жыл бұрын
Sir, I'm looking out for training on ETL testing, May I know contact number to discuss and join the course.. Thank you
@infinitium38632 жыл бұрын
Your recent videos have very low volume. Very hard to hear.