As per the Question, what you said is CORRECT. SELECT MAX(ESAL) FROM EMPLOYEE Sir has given answer for the question - Get the employee details of Employee with highest salary SELECT * FROM EMPLOYEE WHERE ESAL = (SELECT MAX(ESAL) FROM EMPLOYEE)
Bro how to find name and address of acc holder But it's 3 table 1 tabl is cust id and name and address 2 table is acc id and balance 3 table is cust id and acc id Please 🙏 bro it's school assignment
Wrong process of fetching . If you're teaching then you should come up with generalize way. It matched for 2nd Max, if i need to fetch 6th max then i will be doing more nested by less than. That will lead to performance degradation. I'm not saying neither you're wrong nor This query is wrong. But you should be teaching with generalize way. So that every position can be picked by that query. Thank you. Don't misunderstand. I'm also a beginner.
sir, while creating new table with help of existing one, in syntax it is showing error, unable to proceed, create table emp2 as select * from emp1; nd error showing 'Incorrect syntax near the keyword 'select' '.
Sir! I have query regarding IT which course shall opt for B.com candidate for atleast for certification 1yr and main important thing is getting or preference which course candidate get very easily job.
I am getting error in 2nd max salary - An aggregate may not appear in the WHERE clause unless it is in a subquery contained in a HAVING clause or a select list, and the column being aggregated is an outer reference. why I am getting this
Bhai Mera Aaj hi hai exam class 12th ka subah ko dekh raha hu😂😂
Mera 2 ghante me hay😊
I T 😂 23/2/2024 exam से पहले
Kon kon it ke paper pe ye video dekh rahe hai 😝😜 13/3/2023
25/11/23😂😂
@@mrrobot4504 25/11/23
@@mrrobot4504vai mera 27 /11/23 ko 😢
@@B_I_N_G_0 Mera Aaj statistics 🥹
8/12/2023
This is very much beneficial video for us sir keep going on❤
Good bless you . I have tired to find such a question but you clarify it nicely . Thank you sir so much.🙏🙏🙏🙏💯💯💯
Is video ke pehle kis kis ko assian paint ki add aye
Like who are watching in 2024
👇🏻
Select max( esal) from employee;
Is this correct for maximum salary ?
As per the Question, what you said is CORRECT.
SELECT MAX(ESAL) FROM EMPLOYEE
Sir has given answer for the question - Get the employee details of Employee with highest salary
SELECT * FROM EMPLOYEE WHERE ESAL = (SELECT MAX(ESAL) FROM EMPLOYEE)
If we use in and top operator the answer will be right
@@anjalirout6749 What if more than one Employee has MAX SALARY.
TOP 1 gives only one record right ...
Bhai jamshedpur Se ho kya .Mango ,dimna dala hua hain 😍👼
Why you don't use aggression function in first quiry 😅
eaisi hi enterview query most important btao or
Video banane ke liye Thanks..🙏🙏🙏
Thank you so much, sir, for making the lesson understandable and enlightening.
Sir....you upload videos for which class...??????sir please reply 🤧
For every class 5 to master level
Ok....I am in class 5
Select * from youtube
Where Learn codinh = “Subscribe”
😊tq
Bhai saheb app jamshedpur, jharkhand sa ho ..🙄😅😅😄😄😃😃😃gjb
Sakchi - mango 😅😅
Bro how to find name and address of acc holder
But it's 3 table
1 tabl is cust id and name and address
2 table is acc id and balance
3 table is cust id and acc id
Please 🙏 bro it's school assignment
Alternate way of finding 2nd max salary: SELECT * FROM employee ORDER BY salary DESC LIMIT 1,1;
Thanks u so much sir ❤️ helpful video
Sir r o ei rokom video korun plz
Wrong process of fetching . If you're teaching then you should come up with generalize way. It matched for 2nd Max, if i need to fetch 6th max then i will be doing more nested by less than. That will lead to performance degradation. I'm not saying neither you're wrong nor This query is wrong. But you should be teaching with generalize way. So that every position can be picked by that query. Thank you. Don't misunderstand. I'm also a beginner.
Koi Bata skta h ke paper ma koi table aye wahn konci query use ho gi like WHERE COLUSE ,
3:15
SELECT *
FROM emp
ORDER BY esal DESC
LIMIT 2 ;
if i do this method in POSTGRESQL
Please bhaiya SQL ki playlist bnado it will be very very helpful.
Bni hui oracle database ke Name se
Today is our 1st year practical I am watching this vedio😂😂 24/05/2024
Order by, limit 1 or limit 2 for first, second task. Why you make subqueries? Complex code is not good code....
sir, while creating new table with help of existing one, in syntax it is showing error, unable to proceed,
create table emp2 as select * from emp1; nd error showing 'Incorrect syntax near the keyword 'select' '.
Bahut jayada badiya hai yeh please make more video
Sir mere aise que paper pe aate pr Mujhe kuch samjh ni aarha Please sir any solution 😢 aur pure question ni kr payi
2. select * from emp order by salary desc limit 2 ,1
Very easy and informative lecture to well understand for beginners👍
tq sir
Sir please teach cyber security for bca
Good
Thank you and it more help full
This is a very helpful sir.... please continue this series
Bhai.. Address me sonari, kadma Or Bistupur bhi le lete 😉👍✌
सोचने 🤔 से कहाँ मिलते हैं तमन्नाओ के शहर......😇
चलना भी जरूरी है मंजिल को पाने के लिए.....🚶🏻♀️🚶🏻♀️
🙏 शुभ प्रभार 🙏
Please upload all voides related to SQL plzz sir
Please visit oracle database Playlist
Thanks this video helpful my future 😌
Bhai Mai graduate ho simple... But humko Sql aata h kya mere job lag skte h xche package pe
Very easy and informative lecture to well understand for beginners very very amazing video 😊
Sakchi dimna dek le lag rha aap jamshedpur ke ho. Main vi chandil se. Thank you❤️
Don’t write the subject in English if you are not speaking English
select max(salary ) from emplyee;
is this wrong?
Thank you so much fir plz sir my sql ki or bhi ese hi video bnana 12th class ki it topic pr bhi plz sir
Sir RDBMS we need explanation of every concept
This was very useful video to me i want to you upload more video similar type and cover rest command of sql. Thank You !
Thanks this is tooo helpful
Hello aapne SQL ka course kiya ky
Pls ..help mi
SQL full course
ua-cam.com/play/PLqleLpAMfxGDslJolGldBWcdT1FSIhJ1L.html
@@LearnCodingOfficial hu yyyyjjkjj
Make More Videos like this God Bless You
How to find non matching records from two tables: ua-cam.com/video/j9HL_2NIfcE/v-deo.html
Sir very nice concepts and the video was also fully understandable. Keep going sir.
Bhai Kal exam Kai liye best of luck ❤
Sir NoSQL video upload koro plz or Mongodb video upload koro plz
Thank you sir
It's really helpful........
superb keep continue such quality content
Sir Oracle lock table statement ke bare main ek video banayi ye plz ..
Sir i want to list of employees before joining Nov which quary
We will write
Hi sir muje distance calculation ke querie batayiye pl
Very useful and informative❤
Yes this is informative... Make more videos
Thank you sir🙂This is very useful for us ☺️
Bhaiya Window11install kar sakte h free mein??? (Agr haa to video bana do pls pls)
Nice video and its really helpful
sir ,,, nicely explain for beginner,,,,, please provide more than one solution for a qqqqqq.......
Thank u so much sir♾🙏😊
Select * from emp where
(ename,esal) in (select ename,max(esal) group by ename);
I did this in this way is
it correct let me know .
O bhai agr tumko sirf salary chaie then why r u select *
Very helpful video sir...💓 can you plz make a video on interview question of data structure using c.
how you write these data data. i am wring in my sql workbench the result will come 00/00/0000?
Please suggest solution for this
Sir SQL ke upar aur bhi video banaa dijiye please 🙏🙏🙏
Mujhe SQL ki sare query sikhana hai
Damn bro , bht zalim video 🔥🔥. So much info. Thanks. 🙏
Last Q.mein 3 rows delete kiye to 4 kaise aaya comment mein
Please make videos on J2EE because your previous Java one video is very good and beneficial for me.
Thank-you
Excellent bro 👍🏻👍🏻
Sir aap jamshedpur se he . Thank you so much sir ❤
i am watching this after 1 yr but its helpful mow tooo
Thanks your sir
I am sure that you are from Jamshedpur❤
Ham total dekha full video
Select * from emp where rownum
thanks...this vedio is helpfull
This is very important video sir thankyou very much....
Sir! I have query regarding IT which course shall opt for B.com candidate for atleast for certification 1yr and main important thing is getting or preference which course candidate get very easily job.
This sentence was epic or funny when you said ...who's salary is ekkis hazar , gryarah hazar 😂 at 6:12 time
I am getting error in 2nd max salary - An aggregate may not appear in the WHERE clause unless it is in a subquery contained in a HAVING clause or a select list, and the column being aggregated is an outer reference. why I am getting this
Sir ji app Jamshedpur se ho kya???
I appreciate your effort🫡
Good
Sir jamshedpur se h sirf oohi ka name sab likha h 😂
Sir can u plz upload more queries ... it was very helpful for me ...
Sir ji, Thank you so much, this video is really very helpful.
Thanks
We can do another way also by using limit
how to find 3rd highest salarey from table
good explain sir so easy to understand this queries and there uses thank u sir
All watching
one day before exam
Wah kya samjhaya h
More queries we want
If only he could speak English
Sir provide more videos on DBMS your explanation is too good😊😇
Thanks it's very helpful