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

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

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 KZfaq.. 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.

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