在线求教一条SQL语句,跪求
表结构如下
serial_oid dev_key upload_datetime
E77DE715-0DD4-433B-BBC5-2ACB1D207449 88C9D943-A2A5-426C-B913-76838A2583E4 2015-04-11 17:35:18
E1F0ABF5-F3E9-4E3C-82B1-4A1FA772F111 88C9D943-A2A5-426C-B913-76838A2583E4 2015-04-11 17:35:28
2A35AE01-C666-4A9D-B373-7883403D092A 88C9D943-A2A5-426C-B913-76838A2583E4 2015-04-12 17:35:18
CCBD5615-42E4-402C-BA47-FD363BA5F608 88C9D943-A2A5-426C-B913-76838A2583E4 2015-04-12 17:35:28
C6128319-26D1-4DD5-BB0E-8CB795FDD240 88C9D943-A2A5-426C-B913-76838A2583E4 2015-04-13 17:35:18
2BEFA0A7-16E4-4543-A141-B0BADB3F6C1F 88C9D943-A2A5-426C-B913-76838A2583E4 2015-04-13 17:35:28
FF58F1EB-E7B0-4BF0-8328-4316A1F00732 42E03E7D-0A83-4891-8B7E-C718FBFC9397 2015-04-10 17:35:28
CD90BFBA-EB20-426F-9E96-FE520FCFA808 658B52AF-1E07-45B1-A52B-1F8DD2E8B52F 2015-04-10 17:35:28
922058F3-9798-4672-A8D0-8E9712941ABC 658B52AF-1E07-45B1-A52B-1F8DD2E8B52F 2015-04-11 17:35:28
要查询所有dev_key的upload_datetime 大于2天的数据,如果该dev_key只有一条记录不需要查询
所以查询结果应该如下
E77DE715-0DD4-433B-BBC5-2ACB1D207449 88C9D943-A2A5-426C-B913-76838A2583E4 2015-04-11 17:35:18
E1F0ABF5-F3E9-4E3C-82B1-4A1FA772F111 88C9D943-A2A5-426C-B913-76838A2583E4 2015-04-11 17:35:28
CD90BFBA-EB20-426F-9E96-FE520FCFA808 658B52AF-1E07-45B1-A52B-1F8DD2E8B52F 2015-04-10 17:35:28
922058F3-9798-4672-A8D0-8E9712941ABC 658B52AF-1E07-45B1-A52B-1F8DD2E8B52F 2015-04-11 17:35:28
跪求性能好的SQL,谢谢