SQL依赖于来自同一列的项

Question

我有一张桌子，上面有以下记录：

BookingTimeStamp    BookingReloc    AEType
2016-01-14 23:19:24.773 LVWCQL  Seat
2016-01-14 23:19:24.773 LVWCQL  Seat
2016-01-14 23:19:24.773 LVWCQL  Seat
2016-01-14 16:45:29.450 KCCEMG  Baggage
2016-01-14 16:34:07.117 MEZYPN  Insurance
2016-01-14 16:08:40.617 CJXDFK  Insurance
2016-01-14 16:08:40.617 CJXDFK  Insurance
2016-01-14 16:08:40.617 CJXDFK  Insurance
2016-01-14 16:08:40.617 CJXDFK  Insurance
2016-01-14 15:14:51.633 JMILRY  Seat

我想计算列AEType中的重复值。

期望产出：

Seat = 4 

Baggaage = 1

Insurance =5

是否有可能在一个查询中获得它？

Answer 1

使用'group‘将sql条目按不同的参数分组，' count (*)’可用于计算每个不同AEType的sql条目数。

select AEType,count(*) from Table_Name group by AEType;

Answer 2

select AEType,count(*) from table_name
group by AEType;