Learn SQL

Suman Kumar

Creative Problem Solver | AI Explorer | Lifelong Learner | Ex-Citi

Published Jan 15, 2025

Write a SQL query to find out callers whose first and last call was made to the same person on a given day.

Use of Partition by to solve above problem from Phonolog table(shown below). Also, solve the same problem using alternative of Partition by using group by function.

To view or add a comment, sign in

Others also viewed

Important SQL terms and its meaning - Part 6

Rahul K.B 2y
Important SQL terms and its meaning - Part 4

Rahul K.B 2y
SQL Table Macro

Loïc Lefèvre 3y
Code Challenge 3 || SQL

Ahmed Khaleel 2y
Code Challenge 2 || SQL

Ahmed Khaleel 2y
Clean SQL Tables Without FK Hassles

Ishu Miglani 3mo
Code Challenge 1 || SQL

Ahmed Khaleel 2y
SQL >>VIEWS:

chandrashekhar muktapur 1y
SQL HAVING Clause

Dhaivat Vyas 1mo
Reuse query statements in SQL with Cross Apply

Cassio Almeron 5mo

Explore topics

Sales
Marketing
IT Services
Business Administration
HR Management
Engineering
Soft Skills
See All

Write a SQL query to find out callers whose first and last call was made to the same person on a given day.

Others also viewed

Important SQL terms and its meaning - Part 6

Important SQL terms and its meaning - Part 4

SQL Table Macro

Code Challenge 3 || SQL

Code Challenge 2 || SQL

Clean SQL Tables Without FK Hassles

Code Challenge 1 || SQL

SQL >>VIEWS:

SQL HAVING Clause

Reuse query statements in SQL with Cross Apply

Explore topics