Рет қаралды 636,590
#mysql #oracle #dbms #query #top #sqlserver #database
In this video we will see #Top 9 #SQL query Which are very important for the #PlacementPreparation
👉The TOP 9 SQL query are-
✅Find the third-highest salary from the EmployeeInfo table.
✅Find the Nth highest salary from the table without using TOP/limit keyword.
✅Find duplicate rows in a table.
✅Calculate the even and odd records from a table.
✅Display the first and the last record from the EmployeeInfo table.
✅How do you copy all rows of a table using SQL query?
✅Retrieve the list of employees working in the same department.
✅Retrieve the last 3 records from the EmployeeInfo table.
✅Fetch details of employees whose EmpLname ends with an alphabet ‘A’ and contains five alphabets.
⭐Part 2:Top 9 SQL queries for interview -
• PART 2 : Top 9 SQL que...
Please like 👍, subscribe and share......
Follow us on Instagram -
/ codeera_
🙏Thank you so much for watching and your support..
⭐Encapsulation in java-
• Java tutorial|#Encapsu...
⭐DBMS vs RDMS
• DBMS vs RDBMS | What i...
⭐Keys in DBMS
• Types of Keys in DBMS ...
⭐Normalization in DBMS-
• Normalization and its ...
⭐class and object in java-
• What is Class and Obje...
⭐Types of key in DBMS-
• Types of Keys in DBMS ...
⭐how to install java-
• How to Install JAVA JD...
⭐Introduction of java:-
• Introduction to Java i...
⭐Features of java:-
• Features of java Part 2
⭐JVM JRE JDK:-
• JDK JRE JVM in Java Pa...
⭐MySQL Database -
• How to Create Database...
⭐JVM architecture-
• JVM architecture in Java
⭐Difference between oop and pop
• Difference between OOP...