Help: SQL Interview Questions

88479953

Table g_applydetail (g_applyno, g_name, g_cardid)
g_applyno g_name g_cardid
001 Zhang San 350124
002 Lee Si 370103
003 Wang Wu 430105
004 Zhang San 350124
Find out the number of g_cardids with the same g_cardid occurrence number 2 and the number of occurrences?

fanfan1980

select g_cardid, num = count (g_cardid) from g_applydetail group by g_cardid having count (g_cardid)> 1

fanfan1980

create table g_applydetail (g_applyno char (3), g_name nvarchar (10), g_cardid varchar (10))
insert g_applydetail select '001', 'Zhang San', '350124'
union all select '002', 'Li Si', '370103'
union all select '003', 'King Wu', '430105'
union all select '004', 'Zhang San', '350124'

select g_cardid, num = count (g_cardid)
from g_applydetail
group by g_cardid
having count (g_cardid)> 1

--- result
g_cardid num
---------- -----------
350 124 2

(1 row (s) affected)

smallwarrior

Ha ha

3972500

select g_cardid, count (g_cardid) as count
from g_applydetail
group by g_cardid
having count (g_cardid)> = 2

cxs3214

so easy

haigerrual

en
Suggest lsls

muyizouzhao

Is a group\condition
select g_cardid, count (g_cardid) as count from g_applydetail group by g_cardid having count (g_cardid)> 1

浮华世界

Interview questions? !! !!

carlos59

First floor right