select distinct A.* from A,B where A.id = B.g_id and A.fwzid = 2 我那个地方是写的 select distinct A.* from A,B where A.id B.g_id and A.fwzid = 2 好像就会出错,

sql如何取交集有这样两条sql语句select distinct id from a where id='123'select distinct id from a where id='456'我希望能把他们取得他们记录的交集,sql语句该如何写?错了 应该是这样的select distinct temid from a whe group by 和 distinct 的问题select a.partner as pcode, count(distinct(a.deviceid)) as count -- into num4 from test a where a.activationtime >= to_date('2011-4-17', 'yyyy-mm-dd') and a.activationtime < to_date( select distinct A.* from A,B where A.id = B.g_id and A.fwzid = 2 我那个地方是写的 select distinct A.* from A,B where A.id B.g_id and A.fwzid = 2 好像就会出错, distinct 如何提高下面语句的效率select * from(select a_month ,b_name ,count(DISTINCT a.c_no) ,dense_rank() over (partition by a_month order by COUNT( DISTINCT a.c_no) desc) rank fromsut_s aleft join cou_c bon a.ll=b.ll where a_month>='10'group by b_ 这句SQL语句是什么意思.ql=select distinct(selabel) from.sql=select distinct(selabel) from kcwl_labprosellog where isdel=0 &sqlfile& and selabel not in (select distinct(selabel) from kcwl_labprosell) 这个语句是什么作用的.说具 select telnum,count(0),count(distinct othertelnum) from nmk.ljdx_cdr_temp group by telnum select distinct 院系编号=substring(stud_id,4,2) from stud_info 是什么意思 SQL里的DISTINCT什么意思SELECT Sno,AVG(Grade)FROM SCGROUP BY SnoHAVING COUNT(DISTINCT(Sno))>1;既然已经按Sno分类了,再用DISTINCT那HAVING COUNT(DISTINCT(Sno))的值岂不是只能为1? select a house,andthen selectupgrade. 请问sql语句“Select Distinct”是什么意思?可不可以讲一下它的用法1.Select Distinct 货品编码,数量 From 订单信息2.Select Distinct 货品编码 From 订单信息第一句和第二句有什么分别,请高手说说Distinct select a versino,piease! Select a username是什么意思 to select a Select a country是什么意思 Select a password是什么意思? select * from order where clientNo in (select distinct(clientNo) from orders ) 转化为HQL怎么写?order是表名 clientNo是其中一个列名!怎么转换成HQL, 大侠这个查询语句的意思是什么?sql=select DISTINCT 日期 from +tablename+ where 日期>=' +df +' and 日期