For the 2 Minimum Salary and 2 maximum salary we can use ROWNUM clause or Top Clause for MySQL and arrange the Salary coloumn in Asc for min and Desc for Max
we can also a short query for question no 8 select * from employee_info order by salary DESC limit 2; for maximum two salary select * from employee_info order by salary ASC limit 2; for minimum two salary
your videos are very good but you should explain the solutions a bit more precisely as I some of the questions I have seen on leetcode & to understand the solutions we don't have any source unless anybody explaining itin discussion section.
I can understand you problem you can as your doubt here or you can join our telegram channel for further discussion. I will try to provide you best solution Thank you for watching
See there are a lot of question they can ask.. As here sql come up with DBMS so also prepare that. Some of theme are - 1) Joins. 2) Indexing 3) Relationship 4) DDL,DML,DCL 5) Different type of constraints we use in SQL 6) Types of keys And Some basic query you will find on my videos . All the Very Best for your Interview👍.
i want a query to display the name of all employs who has a unique later let consider we have three data bases virat dhoni and sachin among this using "i" we have to print sachin and dhoni please help me
can anyone tell me why my third statement of execution is wrong saying incorrect argument for execution (err code: 1210) # when records are improper or some records are missing or deleted set @count = (select count(id)/2 from employee_info) ; prepare stat from 'select * from employee_info limit ?' ; execute stat using @count;
i have 3 tables 01) table employee (columns are empid,empname , depid) 02) table Department ( columns are depid, dep name) 03) table salary (columns are empid,amount,month). Q) get the empname , how don't get the salary in the month of December
In the Description Box Link for SQL file- drive.google.com/file/d/1zra8F1MUirPEv_eU9kl7xxQAbyv9LRmi/view?usp=sharing Link for query PDF- drive.google.com/file/d/1D4hn8hU4J8toik1Rci9-TpEO5hK73Jn1/view?usp=sharing
Now Everyone can Access those PDF and SQL file. If not then please drop a comment.
Very very very helpful for revision of SQL.Thanks for the good explanation.And one thing is you didi not add this in SQL playlist.Kindly add it.
Yes, you are right . And I just add it to SQL playlist .Thank you for watching.
Very nice video for quick revision. thank you
thanks maam .. this video is very helpful
You are welcome..
Thank you for watching
thanks for Link for query PDF-
Glad to help... You are wel come.
Perfectly Explained 💯
at 5:51 can't we use having after group by instead of where clause ?
THANKS FOR GIVING MOST IMP QUERY
You are Welcome
Very nice explain 🤗👌👌
Thank you 😀
Thanks for this helpful video
So glad that our video helped you. Thank you for watching.
Good 👍👍
Great job! It's very helpful
So glad it helped you... Keep watching
For the 2 Minimum Salary and 2 maximum salary we can use ROWNUM clause or Top Clause for MySQL and arrange the Salary coloumn in Asc for min and Desc for Max
yes ofc but only if youre a noob
Amazing video. Thank You mam
thanqq ma'am please make some video on interview question
Sure. Thank you so much for watching.
Thank you for this video..
You are welcome..
Very nice explain maam
Thank you so much..
we can also a short query for question no 8
select * from employee_info order by salary DESC limit 2; for maximum two salary
select * from employee_info order by salary ASC limit 2; for minimum two salary
exactly we can
2:05 Is there would be one table or two tables? One as E1 and another as E2?
thanks for important questions❤
Video bahut badiya 👌👌👌👍
Yes pls make more sql queries
Very nice video 😍
Thank you so much
Glad you like it
Thanks for Information
3:08 Where's the duplicate value in the sql command prompt i can see any duplicacy
your videos are very good but you should explain the solutions a bit more precisely as I some of the questions I have seen on leetcode & to understand the solutions we don't have any source unless anybody explaining itin discussion section.
I can understand you problem you can as your doubt here or you can join our telegram channel for further discussion. I will try to provide you best solution
Thank you for watching
Can u explain how it's delete 7,8 I'd. I'm confused in 1st query.
Yes I have completed this video
3:06 do we have to create 2 different tables for this query
Good explain
Thank you so much..
Good work...Could you please upload all 9 questions as a text file... thanks...
We will try.
Thank you for watching.
@@CodeEra2020 mam please provide in pdf form we are waiting for your results
P
Mam, i want to practice this queries but i cant access this files?
Now You can Access those files. If not then please drop a comment.
@@CodeEra2020 Thank you😊
Mam, I have AdP technical round
They said prepare Sql
More what questions will ask u know pls suggest most FAQ's in sql for freshers
See there are a lot of question they can ask.. As here sql come up with DBMS so also prepare that.
Some of theme are -
1) Joins.
2) Indexing
3) Relationship
4) DDL,DML,DCL
5) Different type of constraints we use in SQL
6) Types of keys
And Some basic query you will find on my videos .
All the Very Best for your Interview👍.
@@CodeEra2020 thanks 😊 mam 🙌
i want a query to display the name of all employs who has a unique later let consider we have three data bases virat dhoni and sachin among this using "i" we have to print sachin and dhoni please help me
THANK YOU MAM
Most welcome 😊
Thank you for watching.
Madam ji
You should have drawn the tables while explaning.
can u explain difference between oracle nd my sql dbs.
can anyone tell me why my third statement of execution is wrong saying incorrect argument for execution (err code: 1210)
# when records are improper or some records are missing or deleted
set @count = (select count(id)/2 from employee_info) ;
prepare stat from 'select * from employee_info limit ?' ;
execute stat using @count;
Maam apane ye video and isase pahela video ye do videos mai jitani queries padhai hai kya vo sufficient hai interview ke liye ??
These are the important query but there can be N number of possible queries but if you have done these you can write the logic for the other..
@@CodeEra2020 yes maam thank you so much. I got this video just 2 days before my interview. Thanks to you
@@ShivamKendre-fc3su You can also watch this its very important question th-cam.com/video/Gkp9_5Od2o4/w-d-xo.html
mam can you explain query in which we need to use different tables means all data is not in single table.
In upcoming video we will try to use two tables.. Thank you for watching
Output bhi thodi explain kra kro thoda jyada
Will these queries work in Oracle SQL ?
No may be some keyword not supported by Oracle but logic will be same.
great
Can you please create a video on window functions?
sure ,
I will make a video on it.
Keep watching
mast kam karti he tu
to tu bhi kar naa re
May I know the written quires are in Oracle SQL or SQL server?
MySQL
@@CodeEra2020 thank you so much
Mam please send notes
HI, IAM SRINIVAS PLZ PROVIDE IF ANY MSBI MATERIALS LIKE SSIS,SSAS,SSRS....
Find the 3rd ya 4th highest salary.
Please Checkout this video- th-cam.com/video/RbKZmO8a-yc/w-d-xo.html
DENSE_RANK
Please add subtitles
Can't we use ''TOP 50 PERCENT" to get 50% of the table
Same query, and it works fine weather it is in sequence or not
i have 3 tables
01) table employee (columns are empid,empname , depid)
02) table Department ( columns are depid, dep name)
03) table salary (columns are empid,amount,month).
Q) get the empname , how don't get the salary in the month of December
did you try this?
join 1st and 3rd table using emp_id as common kry and see if dec salary is null
Where is the pdf??
In the Description Box
Link for SQL file-
drive.google.com/file/d/1zra8F1MUirPEv_eU9kl7xxQAbyv9LRmi/view?usp=sharing
Link for query PDF-
drive.google.com/file/d/1D4hn8hU4J8toik1Rci9-TpEO5hK73Jn1/view?usp=sharing
not clear explanition improve some clear analyse to understand others
Sure we will try our best in upcoming video. Thanks for Feedback.
Not SQL server! Your code doesn't work on SQL server!
select name , salary+((salary/100)*10) as TotalSalary from employee_info;
Good 👍
Thank you so much for watching.