TechPointFunda’s Post

Getting 3rd Highest Salary in SQL: -------------------------------------- How many ways do you know, to get the 3rd highest salary in SQL? https://lnkd.in/dK3uu5Gt #sqlinterview #sql #techpoint #techpointfundamentals

Gradually playing with SQL Queries. SQL Developer 😀 I spent my break period exploring various methods of interacting with my self-created database through SQL queries.😆 Some Queries conquered and many more to go😀 1)Write an SQL query to fetch the EmpId and FullName of all the employees working under the Manager with id – ‘986’. 2) Write an SQL query to fetch the different projects available from the EmployeeSalary table. 3) Write an SQL query to fetch the count of employees working in project ‘P1’. 4) Write an SQL query to find the maximum, minimum, and average salary of the employees. 5) Write an SQL query to find the employee id whose salary lies in the range of 9000 and 15000. 6) Write an SQL query to fetch all those employees who work on Projects other than P1. 7) Write an SQL query to display the total salary of each employee adding the Salary with Variable value. AND SO ON 🤔 #Data #SQL #SQLExperimentation #DatabaseExploration #SelfCreatedDBFun #BusinessAnalytics #DataAnalytics

Leetcode premium SQL Question Level: Medium. Day 4️⃣4️⃣ of Solving SQL Problem 1️⃣ 1️⃣5️⃣ . Q) 1875. Group Employees of the Same Salary Schema: Create table If Not Exists Employees (employee_id int, name varchar(30), salary int) Truncate table Employees insert into Employees (employee_id, name, salary) values ('2', 'Meir', '3000') insert into Employees (employee_id, name, salary) values ('3', 'Michael', '3000') insert into Employees (employee_id, name, salary) values ('7', 'Addilyn', '7400') insert into Employees (employee_id, name, salary) values ('8', 'Juan', '6100') insert into Employees (employee_id, name, salary) values ('9', 'Kannon', '7400') Solution: WITH CTE AS( SELECT MIN(employee_id) AS id, salary FROM Employees GROUP BY salary HAVING COUNT(employee_id) = 1) SELECT *,DENSE_RANK() OVER(ORDER BY salary) AS team_id FROM Employees E WHERE employee_id NOT IN(SELECT id from CTE) order by team_id, employee_id Your Turn: Feel free to share your own solutions or approaches to this problem in the comments below! Let's learn from each other and grow together. Stay tuned for more SQL challenges and solutions in the coming days. Follow me to keep up with my daily posts! #JobSeeker #sql #sqlserver #tsql #pyspark #dataengineer #tsql #Azuredataengineer #learning #solving #leetcode #sqldaily #ProfessionalDevelopment #RemoteJobs #NewOpportunities #JobSearch

🚀 SQL Challenge Q16 .The table named EMP has eight columns EMPNO NUMBER(4) NOT NULL: A column named EMPNO that can store up to 4-digit numbers. It cannot be empty. ENAME VARCHAR2(10): A column named ENAME that can store up to 10 characters for the employee's name. JOB VARCHAR2(9): A column named JOB that can store up to 9 characters for the employee's job title. MGR NUMBER(4): A column named MGR that can store up to 4-digit numbers for the manager's ID. HIREDATE DATE: A column named HIREDATE to store the date when the employee was hired. SAL NUMBER(7, 2): A column named SAL to store the employee's salary, with up to 7 digits in total, including 2 decimal places. COMM NUMBER(7, 2): A column named COMM to store the employee's commission, with up to 7 digits in total, including 2 decimal places. DEPTNO NUMBER(2): A column named DEPTNO that can store up to 2-digit numbers for the department number. PRIMARY KEY (EMPNO): This makes sure that each EMPNO value is unique and not empty, serving as the primary identifier for each row in the table. A.WRITE A QUERY TO DISPLAY TOP 3 LOWEST SALARIES EMPLOYEE DETAILS FROM EMP TABLE? B.WRITE A QUERY TO DISPLAY DEPARTMENT DETAILS IN WHICH DEPARTMENT EMPLOYEES ARE WORKING ? C.WRITE A QUERY TO DISPLAY DEPARTMENT DETAILS IN WHICH DEPARTMENT EMPLOYEES ARE NOT WORKING ? Difficulty Level : Medium #Oraclesql #SQL #sqlpractice #sqldatabase #mysql #sqlchallenge #sqldatabae #practice #Challenge

🚀 SQL Challenge Q15 .The table named EMP has eight columns EMPNO NUMBER(4) NOT NULL: A column named EMPNO that can store up to 4-digit numbers. It cannot be empty. ENAME VARCHAR2(10): A column named ENAME that can store up to 10 characters for the employee's name. JOB VARCHAR2(9): A column named JOB that can store up to 9 characters for the employee's job title. MGR NUMBER(4): A column named MGR that can store up to 4-digit numbers for the manager's ID. HIREDATE DATE: A column named HIREDATE to store the date when the employee was hired. SAL NUMBER(7, 2): A column named SAL to store the employee's salary, with up to 7 digits in total, including 2 decimal places. COMM NUMBER(7, 2): A column named COMM to store the employee's commission, with up to 7 digits in total, including 2 decimal places. DEPTNO NUMBER(2): A column named DEPTNO that can store up to 2-digit numbers for the department number. PRIMARY KEY (EMPNO): This makes sure that each EMPNO value is unique and not empty, serving as the primary identifier for each row in the table. A.WRITE A QUERY TO DISPLAY EMPLOYEES WHO ARE EARNING 3TH HIGHEST SALARY FROM EACH JOB WISE BY USING DENSE_RANK() ALONG WITH INLINE VIEW? B.WRITE A QUERY DISPLAY THE 3RD SENIOR MOST EMPLOYEE DETAILS FROM EACH DEPTNO WISE BY USING DENSE_RANK() ALONG WITH INLINE VIEW? Difficulty Level : Medium #Oraclesql #SQL #sqlpractice #sqldatabase #mysql #sqlchallenge #sqldatabae

🚀 SQL Challenge Q12 .The table named EMP has eight columns EMPNO NUMBER(4) NOT NULL: A column named EMPNO that can store up to 4-digit numbers. It cannot be empty. ENAME VARCHAR2(10): A column named ENAME that can store up to 10 characters for the employee's name. JOB VARCHAR2(9): A column named JOB that can store up to 9 characters for the employee's job title. MGR NUMBER(4): A column named MGR that can store up to 4-digit numbers for the manager's ID. HIREDATE DATE: A column named HIREDATE to store the date when the employee was hired. SAL NUMBER(7, 2): A column named SAL to store the employee's salary, with up to 7 digits in total, including 2 decimal places. COMM NUMBER(7, 2): A column named COMM to store the employee's commission, with up to 7 digits in total, including 2 decimal places. DEPTNO NUMBER(2): A column named DEPTNO that can store up to 2-digit numbers for the department number. PRIMARY KEY (EMPNO): This makes sure that each EMPNO value is unique and not empty, serving as the primary identifier for each row in the table. A.Write a Query to display employees details who are earning minimum,maximum salary from emp table? B.Write a Query to display the senior most employee details from each deptno wise? C.Write a Query to display employees who are earning maximum salary from each job wise? Difficulty Level : Medium #Oraclesql #SQL #sqlpractice #sqldatabase #mysql #sqlchallenge #sqldatabae

𝐃𝐚𝐲 𝟏𝟗 𝐨𝐟 𝐌𝐲 𝟕𝟓-𝐃𝐚𝐲 𝐃𝐚𝐭𝐚 𝐒𝐜𝐢𝐞𝐧𝐜𝐞 𝐂𝐡𝐚𝐥𝐥𝐞𝐧𝐠𝐞: 𝐌𝐲𝐒𝐐𝐋 𝐒𝐮𝐛𝐪𝐮𝐞𝐫𝐢𝐞𝐬 𝐚𝐧𝐝 𝐃𝐞𝐫𝐢𝐯𝐞𝐝 𝐓𝐚𝐛𝐥𝐞𝐬! Ever wondered how to make SQL queries more efficient or handle complex datasets? 🤔 𝑺𝒖𝒃𝒒𝒖𝒆𝒓𝒊𝒆𝒔 and 𝑫𝒆𝒓𝒊𝒗𝒆𝒅 𝑻𝒂𝒃𝒍𝒆𝒔 are the key to simplifying complicated queries and boosting your SQL skills! 🚀 🔄 𝑾𝒉𝒂𝒕'𝒔 𝒂 𝑺𝒖𝒃𝒒𝒖𝒆𝒓𝒚? A subquery is a query nested inside another query. Think of it like asking a question to get the answer to a bigger question! It's especially useful when you need to filter, calculate, or manipulate data dynamically. Example: SELECT name, salary FROM employees WHERE salary > (SELECT AVG(salary) FROM employees); Here, we’re finding employees whose salaries are above average by using a subquery to calculate the average salary! 🧩 𝑫𝒆𝒓𝒊𝒗𝒆𝒅 𝑻𝒂𝒃𝒍𝒆𝒔: Derived tables are like subqueries but in the FROM clause. They create a temporary table that you can join with other tables. Example: SELECT d.department, COUNT(*) AS employee_count FROM (SELECT department_id, name FROM employees WHERE salary > 50000) AS d GROUP BY d.department; Here, we’re finding departments with employees who earn more than $50k by first creating a temporary derived table. 💡 Why Do They Matter? Both techniques simplify complex queries and enhance performance, especially when dealing with large datasets or needing temporary data manipulations. They’re essential for advanced SQL operations, helping you tackle real-world problems with ease! Do you use subqueries or derived tables in your SQL work? Let’s chat in the comments! #DataScience #SQL #MySQL #Subqueries #DerivedTables #TechSkills #LearningJourney #LinkedInChallenge #DatabaseManagement #CareerDevelopment #75DaysOfDataAnalysisChallenge #entri_elevate #dr_jithapnair #Dr. Jitha P Nair

𝙎𝙌𝙇 𝙌𝙪𝙚𝙧𝙞𝙚𝙨 𝙩𝙤 𝙥𝙧𝙖𝙘𝙩𝙞𝙘𝙚 𝙩𝙝𝙞𝙨 𝙬𝙚𝙚𝙠𝙚𝙣𝙙 𝙩𝙤 𝙜𝙚𝙩 𝙨𝙩𝙖𝙧𝙩𝙚𝙙 𝙬𝙞𝙩𝙝 𝙨𝙦𝙡 : - 𝘊𝘰𝘯𝘴𝘪𝘥𝘦𝘳 𝘢 𝘵𝘢𝘣𝘭𝘦 𝘯𝘢𝘮𝘦𝘥 "𝘦𝘮𝘱𝘭𝘰𝘺𝘦𝘦𝘴" 𝘸𝘪𝘵𝘩 𝘵𝘩𝘦 𝘧𝘰𝘭𝘭𝘰𝘸𝘪𝘯𝘨 𝘤𝘰𝘭𝘶𝘮𝘯𝘴: 𝘪𝘥 (𝘪𝘯𝘵𝘦𝘨𝘦𝘳) 𝘯𝘢𝘮𝘦 (𝘵𝘦𝘹𝘵) 𝘴𝘢𝘭𝘢𝘳𝘺 (𝘯𝘶𝘮𝘦𝘳𝘪𝘤) 𝘥𝘦𝘱𝘢𝘳𝘵𝘮𝘦𝘯𝘵 (𝘵𝘦𝘹𝘵) 𝘩𝘪𝘳_𝘥𝘢𝘵𝘦 (𝘥𝘢𝘵𝘦) #sql 1.      Write an SQL query to find the top 3 highest-paid employees in each department. 2.      Write an SQL query to find the name and salary of the lowest-paid employee in each department. 3.      Write an SQL query to find the name and salary of the highest-paid employee in each department who was hired in the last year. 4.      Write an SQL query to find the name and salary of the highest-paid employee in each department who has been with the company for at least 5 years. 5.      Write an SQL query to find the names of all employees who have the same name as another employee in the company. 6.      Write an SQL query to find the name and salary of the employee who has the highest salary among all employees who were hired in the last year. 7.      Write an SQL query to find the name and salary of the employee who has the highest salary among all employees who have been with the company for at least 10 years. 8.      Write an SQL query to find the name and department of all employees who have been with the company for more than 10 years and have a salary greater than $100,000. 9.      Write an SQL query to find the name and salary of the employee who has the second-highest salary in the company. 10.   Write an SQL query to find the name and department of all employees who have the same manager as another employee in the company. Happy weekend with fun learning! Do follow for more Bharath Kumar G #sqlqueries #practices #learningandgrowing #dataanalytics

Essential SQL Interview Questions for Your Preparation: 1. What is SQL? 2. Explain the difference between INNER JOIN and LEFT JOIN. 3. How do you remove duplicates from a table? 4. What is the purpose of the GROUP BY clause? 5. Explain the difference between CHAR and VARCHAR data types. 6. What is normalization and denormalization in databases? 7. Write a SQL query to find the second highest salary from an Employee table. 8. What is a primary key and a foreign key? 9. How can you prevent SQL injection in your queries? 10. What is the difference between UNION and UNION ALL in SQL? 11. Explain the ACID properties in the context of databases. 12. What is the purpose of the HAVING clause in SQL? 13. Write a query to calculate the total number of orders for each customer. 14. What is a subquery, and how is it different from a JOIN? 15. What is the purpose of the INDEX in a database? 16. How do you perform an UPDATE with JOIN in SQL? 17. Explain the difference between UNION and JOIN. 18. What is a stored procedure? Provide an example. 19. How would you handle NULL values in SQL? 20. What is the difference between a clustered and a non-clustered index? 21. What is the difference between a view and a table? 22. Explain the purpose of the SQL CASE statement. 23. How do you perform a cross join in SQL? 24. What is the purpose of the TRUNCATE statement? 25. Describe the differences between a candidate key, primary key, and a super key. 26. What is the difference between DELETE and TRUNCATE statements? 27. Explain the concept of a self-join with an example. 28. What is the use of the ORDER BY clause in SQL? 29. How do you calculate the average salary for each department in a table? 30. What is normalization and why is it important in databases? 31. What is the purpose of the SQL BETWEEN operator? 32. Explain the difference between a left outer join and a right outer join. 33. How can you optimize a SQL query for better performance? 34. What is the purpose of the SQL LIKE operator? 35. Explain the difference between UNION and JOIN in terms of result sets. #jobs #interviewpreparation #sql #interviewquestions #developer #jobchange #preparation

🚀 SQL Challenge Q14 .The table named EMP has eight columns EMPNO NUMBER(4) NOT NULL: A column named EMPNO that can store up to 4-digit numbers. It cannot be empty. ENAME VARCHAR2(10): A column named ENAME that can store up to 10 characters for the employee's name. JOB VARCHAR2(9): A column named JOB that can store up to 9 characters for the employee's job title. MGR NUMBER(4): A column named MGR that can store up to 4-digit numbers for the manager's ID. HIREDATE DATE: A column named HIREDATE to store the date when the employee was hired. SAL NUMBER(7, 2): A column named SAL to store the employee's salary, with up to 7 digits in total, including 2 decimal places. COMM NUMBER(7, 2): A column named COMM to store the employee's commission, with up to 7 digits in total, including 2 decimal places. DEPTNO NUMBER(2): A column named DEPTNO that can store up to 2-digit numbers for the department number. PRIMARY KEY (EMPNO): This makes sure that each EMPNO value is unique and not empty, serving as the primary identifier for each row in the table. A.Write a Query to Display whose annual salary is more than 25000? B.Write a Query to Fetch the even position rows from emp table by using rownum alias name along with inline view? Difficulty Level : Easy #Oraclesql #SQL #sqlpractice #sqldatabase #mysql #sqlchallenge #sqldatabase