華閱文章網SQL多條件查詢語句
select * from tab_name where 組號='001組' and to_char（日期，'yyyy-mm-dd'）='2013-04-15' and 姓名1='小王'union allselect * from tab_name where 組號='001組' and to_char（日期，'yyyy-mm-dd'）='2013-04-15' and 姓名2='小王'union allselect * from tab_name where 組號='001組' and to_char（日期，'yyyy-mm-dd'）='2013-04-15' and 姓名3='小王'union allselect * from tab_name where 組號='001組' and to_char（日期，'yyyy-mm-dd'）='2013-04-15' and 姓名4='小王'或者是：select * from tab_name where 組號='001組' and to_char（日期，'yyyy-mm-dd'）='2013-04-15' and 姓名1='小王' or 姓名2='小王' or 姓名3='小王' or 姓名4='小王'。
sql多條件查詢語句
SQL = "select * from 檔案 where 1 = 1 "
If * "全部" Then
SQL = SQL & " and " &； "姓名='" & * & "'"
End if
If * "全部" Then
SQL = SQL & " and " &； "年齡='" & * & "'"
End if
If * "全部" Then
SQL = SQL & " and " &； "身高='" & * & "'"
End if
If * "全部" Then
SQL = SQL & " and " &； "體重='" & * & "'"
End if
oracle數據庫中多條件查詢語句怎么寫
1、首先需要打開一個oracle數據庫界面。
2、然后需要打開數據庫的一張表進行查詢。
3、然后需要選擇表右上角的加號鍵。
4、然后需要在編輯器中輸入如下代碼進行數據查詢。
5、然后需要點擊運行查看運行結果。
6、如圖所示為多條件查詢最終結果。
SQL語句條件查詢問題
您的回答已被之前網友使用，請重新編輯！ 。
。.你也可以把這個作為視圖啊create view v_clientInfo as select ClientID,ClientName,ClientPhone,ClientTime,SourceName,ClientsClass,OPeratorNamefrom Client as a,Source as b,Operator as d,ClientClass as cwhere *ID=*ID and *orID=*orID and *D=*D order by ClientID desc 之后就可以：select * from v_clientInfo where ClientsClass like 'D級%'。
。 -- 查詢所有客戶記錄select c.[ClientName],c.[ClientPhone],c.[ClientTime], s.[SourceName], l.[ClientsClass], o.[OperatorName]from Client c left join Source s on c.[SourceID] = s.[SourceID]left join ClientClass l on c.[ClassID] = l.[ClassID]left join Operator o on c.[OperatorID] = o.[OperatorID] -- 1.查詢所有等級為D級的客戶select c.[ClientName],c.[ClientPhone],c.[ClientTime], s.[SourceName], l.[ClientsClass], o.[OperatorName]from Client c left join Source s on c.[SourceID] = s.[SourceID]left join ClientClass l on c.[ClassID] = l.[ClassID] left join Operator o on c.[OperatorID] = o.[OperatorID]where l.[ClientsClass] like 'D級%' --2.查詢名稱為張鵬的客戶 select c.[ClientName],c.[ClientPhone],c.[ClientTime], s.[SourceName], l.[ClientsClass], o.[OperatorName]from Client c left join Source s on c.[SourceID] = s.[SourceID]left join ClientClass l on c.[ClassID] = l.[ClassID] left join Operator o on c.[OperatorID] = o.[OperatorID]where c.[ClientName] = '張鵬' --3.查詢操作員為NO1的客戶 select c.[ClientName],c.[ClientPhone],c.[ClientTime], s.[SourceName], l.[ClientsClass], o.[OperatorName]from Client c left join Source s on c.[SourceID] = s.[SourceID]left join ClientClass l on c.[ClassID] = l.[ClassID] left join Operator o on c.[OperatorID] = o.[OperatorID]where o.[OperatorName] = 'NO1' --4.來源為路過的客戶 select c.[ClientName],c.[ClientPhone],c.[ClientTime], s.[SourceName], l.[ClientsClass], o.[OperatorName]from Client c left join Source s on c.[SourceID] = s.[SourceID]left join ClientClass l on c.[ClassID] = l.[ClassID] left join Operator o on c.[OperatorID] = o.[OperatorID]where s.[SourceName] = '路過' --5.查詢時間為2010-11-1的客戶 select c.[ClientName],c.[ClientPhone],c.[ClientTime], s.[SourceName], l.[ClientsClass], o.[OperatorName]from Client c left join Source s on c.[SourceID] = s.[SourceID]left join ClientClass l on c.[ClassID] = l.[ClassID] left join Operator o on c.[OperatorID] = o.[OperatorID]where c.[ClientTime] = '2010-11-1'。
SQL語句分條件查詢
要和上一行作比較的話， 那要使用 ROW_NUMBER（) 來處理了。
你先執行下面的 SQL， 通過 Number 那一列， 先核對以下，
是不是 Number 為1 的那一行，要顯示 ar
Number 不為1的那一行，不顯示 ar
SELECT
ar,
ROW_NUMBER() OVER (PARTITION BY ar ORDER BY dt) AS Number,
other字段
FROM
(
select
case when a is not null then cast(a as varchar(10)) + ad
when a is null then ad end ar,
dt,
other字段
from
table
where
year(dt) >2008 and stcd = '402015'
) tmpView
order by ar, dt
如果上面的查詢，滿足預期的要求的話，那么使用 CASE WHEN。
將 ROW_NUMBER() OVER (PARTITION BY ar ORDER BY dt) = 1 的， 顯示 ar
其他的，不顯示出來。
SELECT
CASE WHEN
ROW_NUMBER() OVER (PARTITION BY ar ORDER BY dt) = 1 THEN ar
ELSE ''
END AS ar,
other字段
FROM
(
select
case when a is not null then cast(a as varchar(10)) + ad
when a is null then ad end ar,
dt,
other字段
from
table
where
year(dt) >2008 and stcd = '402015'
) tmpView
order by ar, dt