Hello dear viewers!!!
Firstly thank you so much for visiting my channel.
Here you will get free technical tutorials on the technology and languages to include C, C++, Java, Html, CSS, MySQL, Oracle DB, DBMS, data structure, and many more.
My intention behind making this channel is to provide free education to everyone so that they can upgrade themselves with new technology and their concepts.
I always tried to make videos more easy and understanding. If my channel and videos help you to get knowledge and improve your skills. so just hit the subscribe button and for latest video press bell icon and don't forget to like videos.
Join us on Telegram- t.me/joingroupCodeEra
Follow us on Instagram - instagram.com/codeera_/
Пікірлер
select id,name, date_sub(dob,interval 3 years) as update_date_of_birth from employees
Good one
Isme toh mam duplicate entry ke vaja se error aa raha hai
You are explaining in my sql
mam can you make vedios on views , window functions , rank .......................,,like advance topics please 🙂🙂🙂🙂🙂🙂🙂🙂
Excellent Explanation
I answered wrong in puzzle.Except that everything was fine in my digital interview.Will they reject me on that basis??
Are this tables are given in our interview rounds while asking query to us????
This same question how to solve subquery please tell me mam
Hi saloni me interview me join ki query me bar bar fail ho rha ab mujhe smjh nhi aa rha h kya kru
Thank You so much Mam
Thanks sister best and easiest explanation
hi saloni
SELECT C.prod_id, A.cust_name, A.cust_city, B.order_date, C.prod_price FROM customers as A INNER JOIN orders as B ON c.cust_id = o.cust_id INNER JOIN product_details as P ON B.order_id = C.order_id WHERE A.cust_name = 'David';
Thank you sooo much ❤❤❤❤
Excellent teaching skills 😊
You're amazing 🎉!
channel owner disappeared or not in mood to reply
in the first question if there are duplicates of highest salary and if we put a limit, then after sorting how can the third row will be having the third highest salary? my approach using a distinct keyword select * from employeeinfo where salary=(select * from (select distinct(salary) from employeeinfo) as e1 order by age desc limit 2,1); correct me if I am wrong Thank You
Very helpful
Top clause is not working in MySQL workbench
It will not work, in MySQL limit and offset will work
Hi Saloni i want to subtract date from 2 different columns and want the output in days but it is not working kindly suggest
Except is not working in SQL workbench please reply.
Thank you so much saloni😊
create on how to delete duplicate rows;
finally my doubt cleared in simple way very thanks hope you upload this kind of videos which are helpful
Very Nice and helpfull questions
I have done the same but it is not executing 😑.
I have my TCS nqt interview in the upcoming week. This video helps me a lot
did you completed your interview
0:32 only database with same id assigned to multiple employees
Beautifully explained
The result is not acceptable mam sincd the salary should by greater than 5000 there are onlyone in accounting and two in developer having salary more than 5000 but the result showing wrong answer 7:24
select * from practise1 where EmpLname Like '_%a' and length(EmpLname)=5; last vali query in better way!!
Excellent ..unbeatable on KZread.. I'm a big SQL fiyan of yours ..using ur channel now working as a senior developer
Saloni, all your videos are fantastic 👏 👌 🎉. I must admit that this where I finally learnt SQL principles. Very detailed work. Thank you 🙏
quality video.
You are great 👍
Really, superb explaination mam.... Crystal clear
Can i use full outer join for 1 and 2 questions
Left join kyu use Kiya he samja nhi..
please provide all slides of this course playlist
Thanks! Mam, Excellent
System engineer post??? That too after asking topic related to latest technologies and coding.
Its TCS roles, but its not specific you will be working as system engineer, you will get any works Developer,test, support
thanks a lot man
Very easy explanation. Very helpful 😊
Xampp
Every video is good except this video 90% of this video seems to be like u r reading a newspaper, please explain clearly if possible.... Anyway I like ur explanation in all other videos
Simple very short ways.... Explained like a pro... Layman can also understand..... Good teaching 🙏
Plz explain about many to many relationships in mysql
How to know the here we use left join here we use right join to know that