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

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!

Key Moments-
LIMIT & OFFSET - 01:00
LIMIT with ORDER BY - 05:30
Find 3rd Highest Salary - 06:13

📚 SQL Practice Questions -

🔶Create Employee Table

🔶Insert Data into Employee Table

Connect with us on different platforms

📌18- ORDER BY Clause in SQL

📌17-IS NULL & IS NOT NULL Operators | IFNULL() Function

📌16-LIKE & NOT LIKE Operator | Wildcard Characters | ESCAPE Character

📌15-BETWEEN & NOT BETWEEN Operator | IN & NOT IN Operator in SQL

📌14 - AND, OR, NOT Operators in SQL | Logical Operators

📌13 - WHERE Clause in SQL | Types of Operators | Comparison Operator

📌12-SELECT Command in SQL | DISTINCT | FROM Clause

⭐Part 1:Top 9 SQL queries for interview -

⭐Part 2:Top 9 SQL queries for interview -

⭐Top SQL Interview Question

⭐Interview SQL Query On Joins

⭐DBMS vs RDBMS

⭐SQL Query To Swap Value Of Male and Female In Single Statement

#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

[nagendraprasad]

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

[mostaphadahmane]

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

[BaskaranJeevanandham]

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

[patel]

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.

[jeffreystine]

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.

[javajugadcode]

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

[niroshanune]

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

[preetihalder]

Madam, when will today's lecture be published?

[farhanhussain]

its good to use subqueries the answer will be accurate.

[preetihalder]

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

[ArnavBorthakur]

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

[farhanhussain]

mam, in the employee table data in the salary were 6000, 4800, 4000, 3000 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

[masterpiecepreetam]

In last time your query return wrong output