在sql查询中需要不同的列 [英] need different column in sql query

问题描述

**主表结构





投诉名称PhNo CreatedDate状态

PAC000010 Raja 9876543456 2016- 01-14 18:05:04.703 FollowUp1

PAC000016 Raja 9876543456 2016-01-14 19：29：36.530 FollowUp1

PAC000016 Raja 9876543456 2016-01-15 11:10 ：07.170 FollowUp2

PAC000016 Raja 9876543456 2016-01-14 18：32：53.123已结束

PAC000019 Raja 9876543456 2016-01-15 11：13：17.747 FollowUp1




**我需要以下表结构



投诉名称PhNo CreatedDate状态

PAC000019 Raja 9876543456 2016-01-15 11：13：17.747 FollowUp1

PAC000016 Raja 9876543456 2016-01-14 18：32：53.123已结束

PAC000010 Raja 9876543456 2016-01-14 18：05：04.703 FollowUp1

** Main table structure


ComplainId Name PhNo CreatedDate Status
PAC000010 Raja 9876543456 2016-01-14 18:05:04.703 FollowUp1
PAC000016 Raja 9876543456 2016-01-14 19:29:36.530 FollowUp1
PAC000016 Raja 9876543456 2016-01-15 11:10:07.170 FollowUp2
PAC000016 Raja 9876543456 2016-01-14 18:32:53.123 Closed
PAC000019 Raja 9876543456 2016-01-15 11:13:17.747 FollowUp1


**I need the following table structure

ComplainId Name PhNo CreatedDate Status
PAC000019 Raja 9876543456 2016-01-15 11:13:17.747 FollowUp1
PAC000016 Raja 9876543456 2016-01-14 18:32:53.123 Closed
PAC000010 Raja 9876543456 2016-01-14 18:05:04.703 FollowUp1

推荐答案

嗯，这很简单！试试这个

Well it's pretty simple! Try this

SELECT *
FROM   
(
    SELECT ComplainId, MIN(CreatedDate) MIN_DATE
    FROM   MAIN_TABLE
    GROUP BY ComplainId
) T INNER JOIN MAIN_TABLE M ON T.ComplainId = M.ComplainId AND T.MIN_DATE = M.CreatedDate

这篇关于在sql查询中需要不同的列的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！