Write SQL Query to find employees that have the same name and email.

preview_player
Показать описание
This is a simple question with one trick. The trick here is to use Group by on two columns Name and Email.

If you want to be better in Analytics, then do follow the below Playlist:-

You can follow us on the below social media handles:-
  1. The Data Millennials
  2. Write SQL Query to find employees that have the same name and email
  3. sqlinterviewquestionsandanswers
  4. sql
  5. sqlqueries
  6. sqlinterviewquestions
Рекомендации по теме
5 Basic SELECT 0:06:43

5 Basic SELECT Statement Queries in SQL

How to Write 0:01:40

How to Write Basic SQL Statements (SELECT, FROM)

Write SQL Query 0:06:07

Write SQL Query to find employees that have the same name and email.

Learn Basic SQL 0:17:40

Learn Basic SQL in 15 Minutes | Business Intelligence For Beginners | SQL Tutorial For Beginners 1/3

Learn how to 0:49:56

Learn how to write SQL Queries(Practice Complex SQL Queries)

SOLVE 5 SQL 0:05:02

SOLVE 5 SQL QUERIES IN 5 MINUTES (PART 1) | MASTER IN SQL | SQL INTERVIEW QUESTIONS

SELECT query in 0:07:21

SELECT query in SQL - Retrieval of records from a table

Writing your first 0:04:13

Writing your first SQL queries in SQL Server

Basic SQL Query 0:10:06

Basic SQL Query Structure Explained for Beginners! | #datascience #dataanalytics #sqlbasics #sql

SQL indexing best 0:04:08

SQL indexing best practices | How to make your database FASTER!

Part 8 0:04:03

Part 8 SQL Query to find department with highest number of employees

Query To Find 0:04:02

Query To Find highest, lowest and Average Salary In Each Department | SQL Interview Question

How to Approach 0:00:57

How to Approach a SQL Query Step by Step

Part 2 0:10:14

Part 2 SQL query to get organization hierarchy

Part 5 0:04:52

Part 5 SQL query to find employees hired in last n months

Secret To Optimizing 0:05:57

Secret To Optimizing SQL Queries - Understand The SQL Execution Order

Subquery in SQL 1:10:44

Subquery in SQL | Correlated Subquery + Complete SQL Subqueries Tutorial

SQL SELECT Tutorial 0:08:56

SQL SELECT Tutorial |¦| SQL Tutorial |¦| SQL for Beginners

5 Best SQL 0:00:33

5 Best SQL Websites to Practice n Learn Interview Questions for FREE

How to find 0:04:10

How to find second highest salary in SQL

Practice Writing SQL 0:54:41

Practice Writing SQL Queries using Real Dataset(Practice Complex SQL Queries)

SQL Window Function 0:24:55

SQL Window Function | How to write SQL Query using RANK, DENSE RANK, LEAD/LAG | SQL Queries Tutorial

SQL Interview Question 0:05:56

SQL Interview Question # 1 - Write an SQL Query to find the names of the employees starting with A

Write a SQL 0:03:10

Write a SQL query to fetch all the Employees who are also Managers ?

Комментарии
Автор

Nice answer, thanks for the video, your videos are very helpful, one query, if we were to display emplid also then groupby having wont work right

venkatesh
Автор

I want to ask
Why haven’t you used greater than 1? Instead of >=2?

k-fundom
Автор

bro help with this ---> Write an SQL Query to fetch the employee names that have same salary.

lyricsworld
Автор

Hello im not able to find 1 query where i want to find top 10 emp salary from the table .... can you help me with the query ? @thedatamillennials

manthanjn