No video :(

19- LIMIT and OFFSET in SQL | Find Nth highest salary using LIMIT Clause | Interview Question

Подписаться 32 тыс.

Просмотров 6 тыс.

50% 1

Are you new to SQL and looking to learn the basics quickly? Look no further! This tutorial is designed for beginners and will teach you the fundamentals of SQL .
So what are you waiting for? Grab your coffee and let's get started!
Complete SQL Tutorial Playlist- • SQL / MySQL Tutorial
Key Moments-
LIMIT & OFFSET - 01:00
LIMIT with ORDER BY - 05:30
Find 3rd Highest Salary - 06:13
📚 SQL Practice Questions -
codeera.netlif...
🔶Create Employee Table
codeera.netlif...
🔶Insert Data into Employee Table
codeera.netlif...
Connect with us on different platforms
✅ Visit Our Website: codeera.netlif...
✅ Subscribe us on RU-vid: / @codeera2020
✅ Follow us on Instagram: / codeera_
✅ Follow us on Telegram: t.me/joingroup...
📌18- ORDER BY Clause in SQL
• 18- ORDER BY Clause in...
📌17-IS NULL & IS NOT NULL Operators | IFNULL() Function
• 17- IS NULL & IS NOT N...
📌16-LIKE & NOT LIKE Operator | Wildcard Characters | ESCAPE Character
• 16-LIKE Operator & Wil...
📌15-BETWEEN & NOT BETWEEN Operator | IN & NOT IN Operator in SQL
• 15 - SQL BETWEEN & NOT...
📌14 - AND, OR, NOT Operators in SQL | Logical Operators
• 14 - AND, OR, NOT Oper...
📌13 - WHERE Clause in SQL | Types of Operators | Comparison Operator
• 13 - WHERE Clause in S...
📌12-SELECT Command in SQL | DISTINCT | FROM Clause
• 12-SELECT Command in S...
⭐Part 1:Top 9 SQL queries for interview -
• Top 9 SQL queries for ...
⭐Part 2:Top 9 SQL queries for interview -
• PART 2 : Top 9 SQL que...
⭐Top SQL Interview Question
• Top SQL Interview Ques...
⭐Interview SQL Query On Joins
• Interview SQL Query On...
⭐DBMS vs RDBMS
• DBMS vs RDBMS | What i...
⭐SQL Query To Swap Value Of Male and Female In Single Statement
• SQL Query To Swap Valu...
#sql
#sqlcourse
#sqlforbeginners
#datamanagement
#database
#sqltraining
#sqltutorial
#dataanalytics
#dataanalysis
#learnsql
#sqlqueries
#sqlprogramming
#onlinelearning
#techskills
#elearning
#onlinetraining
#programming
#coding
#careerdevelopment
#beginners
#MySQL
#databasemanagement
#DBMS
#techtutorials
#sqlforbeginners
#sqltutorial
#sqlcourse
#sqltraining
#simplilearn
#sqlintroduction
#sqlfullcourse
#oracledatabase
#oracle
#oraclesql
#ask4help
#learncoding
#orderby
#clause
#limit

Опубликовано:

20 авг 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 21

@RahmathnishaShajahan День назад

very helpful

@allurianusha6111 2 месяца назад

Excellent teaching skills 😊

@nagendraprasad4994 5 месяцев назад

Your videos are really helpful a lot , thank u so much

@mostaphadahmane7583 Год назад

thanks a lot my best teacher for this video - best wishes

@patel1111101 5 месяцев назад

Hi, Your SQL videos are fantastic! They've been instrumental in helping me grasp the concepts easily. Thank you for your clear explanations and engaging teaching style. I'm having trouble finding the question-answer link also I'm facing an issue downloading the data. Could you please guide me on where to locate it? Thank you for your assistance.

@CodeEra2020 5 месяцев назад

codeera.netlify.app/sql-practice/ Here you will find all practice question and answers

@jeffreystine4638 5 дней назад

if we use distinct and there are multiple employees with the same salary that means our result set would be incomplete or what do you think.

@user-cl1jd4hv3g 8 месяцев назад

Hi Saloni, Very Good Lectures, Its really helpful. One small thing. I can create the table but couldn't insert data which you were given for sample table link in a description. Its showing error on (gender ENUM ('M','F') NOT NULL). Please check once is there any problem on that particular column. I am using MySQL Workbench for practice. Thank you in advance. Grade Job. Keep it up....

@niroshanune3386 9 месяцев назад

HELLO MAM,VERY NICE EXPLANATION...WHERE CAN I FIND WINDOWS FUNCTIONS IN SQL ?UR VIDEOS ARE VERY HELPFUL...

@preetihalder4758 Год назад

Hello mam in the link there is no question of current LIMIT clause and OFFSET clause..last pdf upload was on order by clause😢

@CodeEra2020 Год назад

Please check the website or link .It's updated now

@ArnavBorthakur 5 месяцев назад

what is offset , you haven't expalined this as in SSMS limit syntax does not work

@farhanhussain7142 8 месяцев назад

its good to use subqueries the answer will be accurate.

@javajugadcode1429 Год назад

Videos are very helpful please make videos in trigger,index,view and stored procedure if possible

@CodeEra2020 Год назад

will upload soon in this SQL tutorial series.

@javajugadcode1429 Год назад

Thank you

@preetihalder4758 Год назад

Madam, when will today's lecture be published?

@farhanhussain7142 8 месяцев назад

mam, in the employee table data in the salary were 6000, 4800,4000, 3000 .......so the 3rd highest salary will be 4000 but the query you performed in the end of the video, the output was coming 3000 which is not correct it should be 4000

@elizastefanescu5390 6 месяцев назад

Hello! If you check again, you'll see that the answer 3000 is correct because in the last example, the output should be the third lowest salary, only in the previous example the question was related to the third highest salary. So, 3000 is correct because the lowest (unique) salaries are: 2000, 2500 and 3000 (ASC not DESC this time - 3000 being the third lowest). Please check again and will make sense. Keep it up!