select
m.name,
i.v_name,
m.usrmsisdn,
d.name as deaprtemantName,
r.name as roomName,
re.n_status,
re.d_storetime as store,
i.d_begintime as begintime,
i.d_endtime as endtime from mwc_member m,
mwc_spike_item i,
mwc_spike_record re,
mwc_room r,
mwc_department d
where i.n_spikeid = re.n_spikeid
and re.v_mobile = m.usrmsisdn
and m.room = r.roomid
and m.department = d.id
order by store"order by"排序后数据出现重复。 去除“ORDER BY”数据正常 急救。哪位大哥解决下。
m.name,
i.v_name,
m.usrmsisdn,
d.name as deaprtemantName,
r.name as roomName,
re.n_status,
re.d_storetime as store,
i.d_begintime as begintime,
i.d_endtime as endtime from mwc_member m,
mwc_spike_item i,
mwc_spike_record re,
mwc_room r,
mwc_department d
where i.n_spikeid = re.n_spikeid
and re.v_mobile = m.usrmsisdn
and m.room = r.roomid
and m.department = d.id
order by store"order by"排序后数据出现重复。 去除“ORDER BY”数据正常 急救。哪位大哥解决下。
order by只是和产生的数据集中数据的顺序有关,怎么会影响到数据集的其他情况呢??
store好像是oracle中的关键字,看是否和其有关。你用order by后产生的数据记录数和不用order by产生的数据记录数一样吗?