Видео

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

Select id, name, subdate(dob, interval 3 year) as updated_date_of_birth from employee;

1) select max(Salary), department from employee_info group by department; 2) select count(ID), gender from employee_info where DOB between 01/01/1960 and 31/12/1975 group by gender; 3)select count(ID) , department from employee_info group by department;

Explanation really awesome

how to insert union data into a new table?

This is actually good, learnt some good things here.

Thank you very much. Keep going. Never stop

Excellent job ma'am 👏 👍 👌 🙌 Thanks 🙏 🙏 🙏

❤❤

for nth higest salary we can use SELECT DISTINCT salary FROM emp ORDER BY salary DESC LIMIT n-1, 1;

❤❤❤

Super ❤❤

Hi @saloni mam I want to learn Pivot in sql for 3 columns and more than 3 columns.please Upload a video regarding Pivot and unpivot

Please how can i get this data you are working with please☺☺☺☺

nice videos sis

self join m two tables create krege to usme inner join ka use krege mem? pls clear the doubt?

self join m two tables create krege to usme inner join ka use krege mem? pls clear the doubt?