For min and max salaries ; you can also use this For together min and max salary in one query Method-1) SELECT (SELECT Salary FROM Employee ORDER BY Salary ASC LIMIT 1) AS MinSalary, (SELECT Salary FROM Employee ORDER BY Salary DESC LIMIT 1) AS MaxSalary; Method-2) SELECT MIN(Salary) AS MinSalary, MAX(Salary) AS MaxSalary FROM Employee; For Separate min and max salary for min SELECT Salary FROM Employee ORDER BY Salary ASC LIMIT 1; For max SELECT Salary FROM Employee ORDER BY Salary DESC LIMIT 1; Btw thanks for uploading such videos, really helpful for interviews.🤍

Asked to me for Smartenc company

Educational 🎉

Hi, is the query for duplicate rows correct, I think we can't use * here, empid should be used instead of *.

Nice Content

I think for the cast one its better to show the actual decimal point for a better example. ill help you. SELECT CAST(10 AS DECIMAL(5, 2)) AS decimal_value; result = decimal_value 10.00

too much add in your videos

After watching this video clear the concept Thank you.../@@##

Select salary From employee_info E1 Where 3= (Select count(distinct salary) From employee_info e2 Where e2.salary >= e1.salary)

mcq q 8 answer ??

Great Explanation in the correct order!

thank you code era.

are there any mock test held before the assessment???

select manager_id as "Manager" , count(manager_id) as "Subordinates" from emp group by manager_id order by manager_id;

Maam is this real test or just mock test?

mam is this test organised in campus or in online mode?

Hello madam

im from the uk, can i come and marry you

4) select department,avg(salary) as avg_salary from employee Group by department;

Hello saloni didi help mi solve this problem write quries to display manager id who have 2 emplayee

Very well explained ma'am

Thank you very very much 🙏🙏🙏🙏🙏🙏

Watched this video for revision before my interview. Luckily the interviewer asked many questions from SQL and I had to write down the queries. This really helped 😍❤️

Very helpful videos thnx ❤

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