Here's the table that I have,

and I need time difference between Group Joined and Group Left of same Number and the Time column in the table is in bona fide datetime format.

And I only need the phone numbers whose time period is More than 12 hours.

I have tried using DATEDIFF but I am somehow not able to get the output I need.

CodePudding user response：

We can use DATEDIFF() along with conditional aggregation:

SELECT Number
FROM yourTable
GROUP BY Number
HAVING DATEDIFF(hour,
                MAX(CASE WHEN Status = 'Group Joined' THEN Time END),
                MAX(CASE WHEN Status = 'Group Left'   THEN Time END)) > 12;

Here the max of CASE expressions find the times for group joined and group left.