SQL查询选择最早的成员 [英] SQL Query selecting the oldest member

问题描述

SELECT membFNme, memberIdNum, MAX(DATEDIFF (YY,substring(memberIdNum, 1,6), GETDATE()))
FROM member
GROUP BY membFNme
HAVING  = MAX (DATEDIFF (YY,substring(memberIdNum, 1,6), GETDATE

我需要在成员表中选择最早的成员

I need to select the oldest member in the member table

推荐答案

您有两种选择:

1.如果MemberIdNum列包含标识或连续数字，则可以将第一个成员作为最早的成员. B''coz，第一个成员将是最老的成员

2.如果MemberIdnum包含日期值，则最低的MemberIDnum值也是最早的成员

因此，您可以使用:

按MemberIdNum从成员顺序中选择前1个membFNme，MemberIdNum

Hi,

You have two options:

1. If the MemberIdNum column contains identity or continuous number, you can take first member as the Oldest member. B''coz, the first member will be the oldest member

2. If the MemberIdnum is containing the datevalue, then also the lowest MemberIDnum value is the oldest member

so, you can use:

select top 1 membFNme, MemberIdNum from member order by MemberIdNum

要获取年龄最大的会员，查询是:

从会员中选择年龄最高的1个memnFNme，memberidNum，dateDiff(yy，membDOBirth，getdate())作为年龄
按membDOBirth排序

Hi,

for getting the oldest member with Age, the query is:

select top 1 memnFNme, memberidNum, dateDiff(yy,membDOBirth,getdate()) as Age from Member
order by membDOBirth

这篇关于SQL查询选择最早的成员的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！