Here are some tricky🧩 SQL interview questions!
1. Find the second-highest salary in a table without using LIMIT or TOP.
2. Write a SQL query to find all employees who earn more than their managers.
3. Find the duplicate rows in a table without using GROUP BY.
4. Write a SQL query to find the top 10% of earners in a table.
5. Find the cumulative sum of a column in a table.
6. Write a SQL query to find all employees who have never taken a leave.
7. Find the difference between the current row and the next row in a table.
8. Write a SQL query to find all departments with more than one employee.
9. Find the maximum value of a column for each group without using GROUP BY.
10. Write a SQL query to find all employees who have taken more than 3 leaves in a month.
These questions are designed to test your SQL skills, including your ability to write efficient queries, think creatively, and solve complex problems.
Here are the answers to these questions:
1. SELECT MAX(salary) FROM table WHERE salary NOT IN (SELECT MAX(salary) FROM table)
2. SELECT e1.* FROM employees e1 JOIN employees e2 ON e1.manager_id = (link unavailable) WHERE e1.salary > e2.salary
3. SELECT * FROM table WHERE rowid IN (SELECT rowid FROM table GROUP BY column HAVING COUNT(*) > 1)
4. SELECT * FROM table WHERE salary > (SELECT PERCENTILE_CONT(0.9) WITHIN GROUP (ORDER BY salary) FROM table)
5. SELECT column, SUM(column) OVER (ORDER BY rowid) FROM table
6. SELECT * FROM employees WHERE id NOT IN (SELECT employee_id FROM leaves)
7. SELECT *, column - LEAD(column) OVER (ORDER BY rowid) FROM table
8. SELECT department FROM employees GROUP BY department HAVING COUNT(*) > 1
9. SELECT MAX(column) FROM table WHERE column NOT IN (SELECT MAX(column) FROM table GROUP BY group_column)
1. Find the second-highest salary in a table without using LIMIT or TOP.
2. Write a SQL query to find all employees who earn more than their managers.
3. Find the duplicate rows in a table without using GROUP BY.
4. Write a SQL query to find the top 10% of earners in a table.
5. Find the cumulative sum of a column in a table.
6. Write a SQL query to find all employees who have never taken a leave.
7. Find the difference between the current row and the next row in a table.
8. Write a SQL query to find all departments with more than one employee.
9. Find the maximum value of a column for each group without using GROUP BY.
10. Write a SQL query to find all employees who have taken more than 3 leaves in a month.
These questions are designed to test your SQL skills, including your ability to write efficient queries, think creatively, and solve complex problems.
Here are the answers to these questions:
1. SELECT MAX(salary) FROM table WHERE salary NOT IN (SELECT MAX(salary) FROM table)
2. SELECT e1.* FROM employees e1 JOIN employees e2 ON e1.manager_id = (link unavailable) WHERE e1.salary > e2.salary
3. SELECT * FROM table WHERE rowid IN (SELECT rowid FROM table GROUP BY column HAVING COUNT(*) > 1)
4. SELECT * FROM table WHERE salary > (SELECT PERCENTILE_CONT(0.9) WITHIN GROUP (ORDER BY salary) FROM table)
5. SELECT column, SUM(column) OVER (ORDER BY rowid) FROM table
6. SELECT * FROM employees WHERE id NOT IN (SELECT employee_id FROM leaves)
7. SELECT *, column - LEAD(column) OVER (ORDER BY rowid) FROM table
8. SELECT department FROM employees GROUP BY department HAVING COUNT(*) > 1
9. SELECT MAX(column) FROM table WHERE column NOT IN (SELECT MAX(column) FROM table GROUP BY group_column)
❤5
⌨️ JavaScript Code Security
JavaScript security requires proactive measures: sanitize inputs, avoid risky functions like eval(), use HTTPS, and keep dependencies updated. Implement these practices to protect your apps from common threats.
JavaScript security requires proactive measures: sanitize inputs, avoid risky functions like eval(), use HTTPS, and keep dependencies updated. Implement these practices to protect your apps from common threats.
❤3🔥2
🔰 Keep your multi-tab web apps in sync.
lets you send messages between tabs instantly, avoiding inconsistent state and improving user experience.
❤6
❤5
📉 Global layoffs signal the end of stable employment
Mass job cuts are sweeping across industries, marking a shift away from long-term, stable employment. The global labor market has entered a period of deep uncertainty, with some companies downsizing aggressively and others freezing new hires altogether.
Over the past year, major corporations have announced significant reductions:
• UPS — 48,000 jobs
• Meta — up to 25,000 by year-end
• Intel — 24,000
• Nestlé — 16,000
• Microsoft — 15,000
• Amazon — 14,000
• Accenture — 11,000
• Novo Nordisk — 9,000
• Procter & Gamble — 7,000
• PwC — 5,600
• Salesforce — 4,000
• Target — 1,800
• Applied Materials — 1,400
• Paramount — 1,000
• Ford — 1,000
No sector has been spared, from tech to manufacturing and consumer goods. While companies officially describe these moves as “restructuring,” analysts point to rising investment in AI and automation as the real catalyst.
The transition has begun and the future of work may never look the same.
Mass job cuts are sweeping across industries, marking a shift away from long-term, stable employment. The global labor market has entered a period of deep uncertainty, with some companies downsizing aggressively and others freezing new hires altogether.
Over the past year, major corporations have announced significant reductions:
• UPS — 48,000 jobs
• Meta — up to 25,000 by year-end
• Intel — 24,000
• Nestlé — 16,000
• Microsoft — 15,000
• Amazon — 14,000
• Accenture — 11,000
• Novo Nordisk — 9,000
• Procter & Gamble — 7,000
• PwC — 5,600
• Salesforce — 4,000
• Target — 1,800
• Applied Materials — 1,400
• Paramount — 1,000
• Ford — 1,000
No sector has been spared, from tech to manufacturing and consumer goods. While companies officially describe these moves as “restructuring,” analysts point to rising investment in AI and automation as the real catalyst.
The transition has begun and the future of work may never look the same.
❤2
🔰 Flexbox in CSS
Flexbox simplifies responsive design by allowing flexible, efficient alignment and distribution of elements without relying on floats or complex CSS hacks.
Flexbox simplifies responsive design by allowing flexible, efficient alignment and distribution of elements without relying on floats or complex CSS hacks.
❤6