Zaynul Abadin Tuhin

使用子查询尝试

select * from person
where (firstname
,      lastname
,      address) in (

select firstname
,      lastname
,      address from person
group by firstname
,      lastname
,      address having count(*)>1
)

输出

id  firstname   lastname    address
3   John        Smith      100 MAIN ST

6   John        Smith      100 main St

demo

mysql中的年月函数

select year(task_completion),month(task_completion) from task

但是如果你需要一年一个月的使用 DATE_FORMAT

 select  DATE_FORMAT(task_completion,'%Y-%m') from task

一种方法可以存在并联合所有

select t1.* from location t1
where exists ( select 1 from location t2 where t2.name=t1.name and t2.feature_code='RGN'
             )
 and t1.feature_code='RGN'
union all

select t1.* from location t1
where not exists ( select 1 from location t2 where t2.name=t1.name and 
                t2.feature_code='RGN'
                  )
  and t1.id=(select min(id) from location t2 where t2.name=t1.name)

像下面这样试试

import datetime from date

today = date.today()


stmt = "select agent_email,aht_in_secs,queueid,EFFORTSCORE from facts.public.customer_interaction_fact where agent_email <> 'Bot' and aht_in_secs is not NULL and to_date(DT) >=" + today + "ORDER BY CONVERSATION_CREATED_TIME DESC"

为了工会和工会,你必须考虑以下几点

1. union中的每个select语句必须具有相同的 柱

2. 列还必须具有类似的数据类型

3. 每个select语句中的列也必须按相同的顺序排列

因此,在两个表合并的情况下,最好使用表中的select all(select*)列,而不是像下面这样显式地使用列名

 select col1,col2... coln from t1
 union 
 select col1,col2.....coln from t2

对于mssql,可以使用row_number()窗口函数

select * from 
(
select *, row_number() over(order by col1) rn from t
) t1 where t1.rn=1 -- 2 or 3, n

搜索字符串中只能使用1GB

 select * from t1 where  item like '%1GB%'

否则,必须使用全文搜索,但要使用它,必须在表中实现它。