Linq学习(三)-基本查询
linq
主要
介紹
內容
基本
學習
查詢
一、本将主要介绍内容 从linq，sql，lambda三个角度比较来学习 select、orderby、分页、group by、distinct、子查询、in的用法 1.select 查询用户和它们的自我介绍 Linq to sql from a in Blog_UserInfo select new { 真实名字 = a.RealName, 自我介绍 = a.I
一、本将主要介绍内容
从linq，sql，lambda三个角度比较来学习
select、orderby、分页、group by、distinct、子查询、in的用法
1.select
查询用户和它们的自我介绍
Linq to sql
<span style="color: #0000ff">from</span> a <span style="color: #0000ff">in</span><span style="color: #000000"> Blog_UserInfo
</span><span style="color: #0000ff">select</span> <span style="color: #0000ff">new</span><span style="color: #000000">
{
真实名字</span>=<span style="color: #000000">a.RealName,
自我介绍</span>=<span style="color: #000000">a.Introduce
}</span>登入後複製
sql
<span style="color: #0000ff">SELECT</span> <span style="color: #ff0000">[</span><span style="color: #ff0000">t0</span><span style="color: #ff0000">]</span>.<span style="color: #ff0000">[</span><span style="color: #ff0000">RealName</span><span style="color: #ff0000">]</span> <span style="color: #0000ff">AS</span> <span style="color: #ff0000">[</span><span style="color: #ff0000">真实名字</span><span style="color: #ff0000">]</span>, <span style="color: #ff0000">[</span><span style="color: #ff0000">t0</span><span style="color: #ff0000">]</span>.<span style="color: #ff0000">[</span><span style="color: #ff0000">Introduce</span><span style="color: #ff0000">]</span> <span style="color: #0000ff">AS</span> <span style="color: #ff0000">[</span><span style="color: #ff0000">自我介绍</span><span style="color: #ff0000">]</span> <span style="color: #0000ff">FROM</span> <span style="color: #ff0000">[</span><span style="color: #ff0000">Blog_UserInfo</span><span style="color: #ff0000">]</span> <span style="color: #0000ff">AS</span> <span style="color: #ff0000">[</span><span style="color: #ff0000">t0</span><span style="color: #ff0000">]</span>
登入後複製
Lambda
<span style="color: #000000">Blog_UserInfo
.Select (
a </span>=>
<span style="color: #0000ff">new</span><span style="color: #000000">
{
真实名字 </span>=<span style="color: #000000"> a.RealName,
自我介绍 </span>=<span style="color: #000000"> a.Introduce
}
)</span>登入後複製
2.orderby
查询名字里带friend的用户，并排序
Linq to sql
<span style="color: #0000ff">from</span> a <span style="color: #808080">in</span><span style="color: #000000"> Blog_Users
</span><span style="color: #0000ff">where</span> a.NickName.<span style="color: #0000ff">Contains</span><span style="color: #000000">("Friend")
orderby a.UserId ascending,
a.CreateTime descending
</span><span style="color: #0000ff">select</span><span style="color: #000000"> a
</span><span style="color: #008080">--</span><span style="color: #008080">或者</span>
<span style="color: #0000ff">from</span> a <span style="color: #808080">in</span><span style="color: #000000"> Blog_Users
</span><span style="color: #0000ff">where</span> a.NickName.<span style="color: #0000ff">Contains</span><span style="color: #000000">("Friend")
orderby a.UserId,a.CreateTime
</span><span style="color: #0000ff">select</span> a登入後複製
sql
<span style="color: #008080">-- Region</span><span style="color: #008080"> Parameters</span> <span style="color: #0000ff">DECLARE</span> <span style="color: #008000">@p0</span> <span style="color: #0000ff">NVarChar</span>(<span style="font-weight: bold; color: #800000">1000</span>) <span style="color: #808080">=</span> <span style="color: #ff0000">'</span><span style="color: #ff0000">%Friend%</span><span style="color: #ff0000">'</span> <span style="color: #008080">-- EndRegion </span><span style="color: #0000ff">SELECT</span> <span style="color: #ff0000">[</span><span style="color: #ff0000">t0</span><span style="color: #ff0000">]</span>.<span style="color: #ff0000">[</span><span style="color: #ff0000">UserId</span><span style="color: #ff0000">]</span>, <span style="color: #ff0000">[</span><span style="color: #ff0000">t0</span><span style="color: #ff0000">]</span>.<span style="color: #ff0000">[</span><span style="color: #ff0000">NickName</span><span style="color: #ff0000">]</span>, <span style="color: #ff0000">[</span><span style="color: #ff0000">t0</span><span style="color: #ff0000">]</span>.<span style="color: #ff0000">[</span><span style="color: #ff0000">CreateTime</span><span style="color: #ff0000">]</span> <span style="color: #0000ff">FROM</span> <span style="color: #ff0000">[</span><span style="color: #ff0000">Blog_User</span><span style="color: #ff0000">]</span> <span style="color: #0000ff">AS</span> <span style="color: #ff0000">[</span><span style="color: #ff0000">t0</span><span style="color: #ff0000">]</span> <span style="color: #0000ff">WHERE</span> <span style="color: #ff0000">[</span><span style="color: #ff0000">t0</span><span style="color: #ff0000">]</span>.<span style="color: #ff0000">[</span><span style="color: #ff0000">NickName</span><span style="color: #ff0000">]</span> <span style="color: #808080">LIKE</span> <span style="color: #008000">@p0</span> <span style="color: #0000ff">ORDER</span> <span style="color: #0000ff">BY</span> <span style="color: #ff0000">[</span><span style="color: #ff0000">t0</span><span style="color: #ff0000">]</span>.<span style="color: #ff0000">[</span><span style="color: #ff0000">UserId</span><span style="color: #ff0000">]</span>, <span style="color: #ff0000">[</span><span style="color: #ff0000">t0</span><span style="color: #ff0000">]</span>.<span style="color: #ff0000">[</span><span style="color: #ff0000">CreateTime</span><span style="color: #ff0000">]</span> <span style="color: #0000ff">DESC</span>
登入後複製
Lambda
<span style="color: #000000">Blog_Users .Where (a </span>=> a.NickName.Contains (<span style="color: #800000">"</span><span style="color: #800000">Friend</span><span style="color: #800000">"</span><span style="color: #000000">)) .OrderBy (a </span>=><span style="color: #000000"> a.UserId) .ThenByDescending (a </span>=> a.CreateTime)
登入後複製
3.分页
按照每页2条 ，查询第2页的留言表的信息
Linq to sql
(<span style="color: #0000ff">from</span> a <span style="color: #0000ff">in</span> Blog_LeaveMsgs <span style="color: #0000ff">select</span> a).Skip(<span style="color: #800080">2</span>).Take(<span style="color: #800080">2</span>)
登入後複製
sql
<span style="color: #008080">-- Region</span><span style="color: #008080"> Parameters</span>
<span style="color: #0000ff">DECLARE</span> <span style="color: #008000">@p0</span> <span style="color: #0000ff">Int</span> <span style="color: #808080">=</span> <span style="font-weight: bold; color: #800000">2</span>
<span style="color: #0000ff">DECLARE</span> <span style="color: #008000">@p1</span> <span style="color: #0000ff">Int</span> <span style="color: #808080">=</span> <span style="font-weight: bold; color: #800000">2</span>
<span style="color: #008080">-- EndRegion
</span><span style="color: #0000ff">SELECT</span> <span style="color: #ff0000">[</span><span style="color: #ff0000">t1</span><span style="color: #ff0000">]</span>.<span style="color: #ff0000">[</span><span style="color: #ff0000">ID</span><span style="color: #ff0000">]</span>, <span style="color: #ff0000">[</span><span style="color: #ff0000">t1</span><span style="color: #ff0000">]</span>.<span style="color: #ff0000">[</span><span style="color: #ff0000">ReceiverId</span><span style="color: #ff0000">]</span>, <span style="color: #ff0000">[</span><span style="color: #ff0000">t1</span><span style="color: #ff0000">]</span>.<span style="color: #ff0000">[</span><span style="color: #ff0000">LeaverId</span><span style="color: #ff0000">]</span>, <span style="color: #ff0000">[</span><span style="color: #ff0000">t1</span><span style="color: #ff0000">]</span>.<span style="color: #ff0000">[</span><span style="color: #ff0000">CreateTime</span><span style="color: #ff0000">]</span>, <span style="color: #ff0000">[</span><span style="color: #ff0000">t1</span><span style="color: #ff0000">]</span>.<span style="color: #ff0000">[</span><span style="color: #ff0000">Content</span><span style="color: #ff0000">]</span>
<span style="color: #0000ff">FROM</span><span style="color: #000000"> (
</span><span style="color: #0000ff">SELECT</span> ROW_NUMBER() <span style="color: #0000ff">OVER</span> (<span style="color: #0000ff">ORDER</span> <span style="color: #0000ff">BY</span> <span style="color: #ff0000">[</span><span style="color: #ff0000">t0</span><span style="color: #ff0000">]</span>.<span style="color: #ff0000">[</span><span style="color: #ff0000">ID</span><span style="color: #ff0000">]</span>, <span style="color: #ff0000">[</span><span style="color: #ff0000">t0</span><span style="color: #ff0000">]</span>.<span style="color: #ff0000">[</span><span style="color: #ff0000">ReceiverId</span><span style="color: #ff0000">]</span>, <span style="color: #ff0000">[</span><span style="color: #ff0000">t0</span><span style="color: #ff0000">]</span>.<span style="color: #ff0000">[</span><span style="color: #ff0000">LeaverId</span><span style="color: #ff0000">]</span>, <span style="color: #ff0000">[</span><span style="color: #ff0000">t0</span><span style="color: #ff0000">]</span>.<span style="color: #ff0000">[</span><span style="color: #ff0000">CreateTime</span><span style="color: #ff0000">]</span>, <span style="color: #ff0000">[</span><span style="color: #ff0000">t0</span><span style="color: #ff0000">]</span>.<span style="color: #ff0000">[</span><span style="color: #ff0000">Content</span><span style="color: #ff0000">]</span>) <span style="color: #0000ff">AS</span> <span style="color: #ff0000">[</span><span style="color: #ff0000">ROW_NUMBER</span><span style="color: #ff0000">]</span>, <span style="color: #ff0000">[</span><span style="color: #ff0000">t0</span><span style="color: #ff0000">]</span>.<span style="color: #ff0000">[</span><span style="color: #ff0000">ID</span><span style="color: #ff0000">]</span>, <span style="color: #ff0000">[</span><span style="color: #ff0000">t0</span><span style="color: #ff0000">]</span>.<span style="color: #ff0000">[</span><span style="color: #ff0000">ReceiverId</span><span style="color: #ff0000">]</span>, <span style="color: #ff0000">[</span><span style="color: #ff0000">t0</span><span style="color: #ff0000">]</span>.<span style="color: #ff0000">[</span><span style="color: #ff0000">LeaverId</span><span style="color: #ff0000">]</span>, <span style="color: #ff0000">[</span><span style="color: #ff0000">t0</span><span style="color: #ff0000">]</span>.<span style="color: #ff0000">[</span><span style="color: #ff0000">CreateTime</span><span style="color: #ff0000">]</span>, <span style="color: #ff0000">[</span><span style="color: #ff0000">t0</span><span style="color: #ff0000">]</span>.<span style="color: #ff0000">[</span><span style="color: #ff0000">Content</span><span style="color: #ff0000">]</span>
<span style="color: #0000ff">FROM</span> <span style="color: #ff0000">[</span><span style="color: #ff0000">Blog_LeaveMsg</span><span style="color: #ff0000">]</span> <span style="color: #0000ff">AS</span> <span style="color: #ff0000">[</span><span style="color: #ff0000">t0</span><span style="color: #ff0000">]</span><span style="color: #000000">
) </span><span style="color: #0000ff">AS</span> <span style="color: #ff0000">[</span><span style="color: #ff0000">t1</span><span style="color: #ff0000">]</span>
<span style="color: #0000ff">WHERE</span> <span style="color: #ff0000">[</span><span style="color: #ff0000">t1</span><span style="color: #ff0000">]</span>.<span style="color: #ff0000">[</span><span style="color: #ff0000">ROW_NUMBER</span><span style="color: #ff0000">]</span> <span style="color: #808080">BETWEEN</span> <span style="color: #008000">@p0</span> <span style="color: #808080">+</span> <span style="font-weight: bold; color: #800000">1</span> <span style="color: #808080">AND</span> <span style="color: #008000">@p0</span> <span style="color: #808080">+</span> <span style="color: #008000">@p1</span>
<span style="color: #0000ff">ORDER</span> <span style="color: #0000ff">BY</span> <span style="color: #ff0000">[</span><span style="color: #ff0000">t1</span><span style="color: #ff0000">]</span>.<span style="color: #ff0000">[</span><span style="color: #ff0000">ROW_NUMBER</span><span style="color: #ff0000">]</span>登入後複製
Lambda
<span style="color: #000000">Blog_LeaveMsgs .Select (a </span>=><span style="color: #000000"> a) .Skip (</span><span style="color: #800080">2</span><span style="color: #000000">) .Take (</span><span style="color: #800080">2</span>)
登入後複製
4.1分组1（group by字段）
根据用户来分组，查询留言数大于等于3条的用户ID和相应留言数量
Linq to sql
<span style="color: #0000ff">from</span> a <span style="color: #0000ff">in</span><span style="color: #000000"> Blog_LeaveMsgs
group a by a.LeaverId into b
</span><span style="color: #0000ff">where</span> b.Count() >=<span style="color: #800080">3</span>
<span style="color: #0000ff">select</span> <span style="color: #0000ff">new</span><span style="color: #000000">
{
朋友ID </span>=<span style="color: #000000"> b.Key,
留言数 </span>=<span style="color: #000000"> b.Count()
}</span>登入後複製
sql
<span style="color: #008080">-- Region</span><span style="color: #008080"> Parameters</span>
<span style="color: #0000ff">DECLARE</span> <span style="color: #008000">@p0</span> <span style="color: #0000ff">Int</span> <span style="color: #808080">=</span> <span style="font-weight: bold; color: #800000">3</span>
<span style="color: #008080">-- EndRegion
</span><span style="color: #0000ff">SELECT</span> <span style="color: #ff0000">[</span><span style="color: #ff0000">t1</span><span style="color: #ff0000">]</span>.<span style="color: #ff0000">[</span><span style="color: #ff0000">LeaverId</span><span style="color: #ff0000">]</span> <span style="color: #0000ff">AS</span> <span style="color: #ff0000">[</span><span style="color: #ff0000">朋友ID</span><span style="color: #ff0000">]</span>, <span style="color: #ff0000">[</span><span style="color: #ff0000">t1</span><span style="color: #ff0000">]</span>.<span style="color: #ff0000">[</span><span style="color: #ff0000">value2</span><span style="color: #ff0000">]</span> <span style="color: #0000ff">AS</span> <span style="color: #ff0000">[</span><span style="color: #ff0000">留言数</span><span style="color: #ff0000">]</span>
<span style="color: #0000ff">FROM</span><span style="color: #000000"> (
</span><span style="color: #0000ff">SELECT</span> <span style="color: #ff00ff">COUNT</span>(<span style="color: #808080">*</span>) <span style="color: #0000ff">AS</span> <span style="color: #ff0000">[</span><span style="color: #ff0000">value</span><span style="color: #ff0000">]</span>, <span style="color: #ff00ff">COUNT</span>(<span style="color: #808080">*</span>) <span style="color: #0000ff">AS</span> <span style="color: #ff0000">[</span><span style="color: #ff0000">value2</span><span style="color: #ff0000">]</span>, <span style="color: #ff0000">[</span><span style="color: #ff0000">t0</span><span style="color: #ff0000">]</span>.<span style="color: #ff0000">[</span><span style="color: #ff0000">LeaverId</span><span style="color: #ff0000">]</span>
<span style="color: #0000ff">FROM</span> <span style="color: #ff0000">[</span><span style="color: #ff0000">Blog_LeaveMsg</span><span style="color: #ff0000">]</span> <span style="color: #0000ff">AS</span> <span style="color: #ff0000">[</span><span style="color: #ff0000">t0</span><span style="color: #ff0000">]</span>
<span style="color: #0000ff">GROUP</span> <span style="color: #0000ff">BY</span> <span style="color: #ff0000">[</span><span style="color: #ff0000">t0</span><span style="color: #ff0000">]</span>.<span style="color: #ff0000">[</span><span style="color: #ff0000">LeaverId</span><span style="color: #ff0000">]</span><span style="color: #000000">
) </span><span style="color: #0000ff">AS</span> <span style="color: #ff0000">[</span><span style="color: #ff0000">t1</span><span style="color: #ff0000">]</span>
<span style="color: #0000ff">WHERE</span> <span style="color: #ff0000">[</span><span style="color: #ff0000">t1</span><span style="color: #ff0000">]</span>.<span style="color: #ff0000">[</span><span style="color: #ff0000">value</span><span style="color: #ff0000">]</span> <span style="color: #808080">>=</span> <span style="color: #008000">@p0</span>登入後複製
4.2分组2（group by多个字段）
按照接收人和留言人进行分组，查看覆盖的接收人和留言人情况
Linq to sql
<span style="color: #0000ff">from</span> a <span style="color: #0000ff">in</span><span style="color: #000000"> Blog_LeaveMsgs
group a by </span><span style="color: #0000ff">new</span><span style="color: #000000">{a.ReceiverId,a.LeaverId} into b
</span><span style="color: #0000ff">select</span> <span style="color: #0000ff">new</span><span style="color: #000000">
{
接收人ID</span>=<span style="color: #000000">b.Key.ReceiverId,
留言人ID</span>=<span style="color: #000000">b.Key.LeaverId
}</span>登入後複製
sql
<span style="color: #0000ff">SELECT</span> <span style="color: #ff0000">[</span><span style="color: #ff0000">t0</span><span style="color: #ff0000">]</span>.<span style="color: #ff0000">[</span><span style="color: #ff0000">ReceiverId</span><span style="color: #ff0000">]</span> <span style="color: #0000ff">AS</span> <span style="color: #ff0000">[</span><span style="color: #ff0000">接收人ID</span><span style="color: #ff0000">]</span>, <span style="color: #ff0000">[</span><span style="color: #ff0000">t0</span><span style="color: #ff0000">]</span>.<span style="color: #ff0000">[</span><span style="color: #ff0000">LeaverId</span><span style="color: #ff0000">]</span> <span style="color: #0000ff">AS</span> <span style="color: #ff0000">[</span><span style="color: #ff0000">留言人ID</span><span style="color: #ff0000">]</span> <span style="color: #0000ff">FROM</span> <span style="color: #ff0000">[</span><span style="color: #ff0000">Blog_LeaveMsg</span><span style="color: #ff0000">]</span> <span style="color: #0000ff">AS</span> <span style="color: #ff0000">[</span><span style="color: #ff0000">t0</span><span style="color: #ff0000">]</span> <span style="color: #0000ff">GROUP</span> <span style="color: #0000ff">BY</span> <span style="color: #ff0000">[</span><span style="color: #ff0000">t0</span><span style="color: #ff0000">]</span>.<span style="color: #ff0000">[</span><span style="color: #ff0000">ReceiverId</span><span style="color: #ff0000">]</span>, <span style="color: #ff0000">[</span><span style="color: #ff0000">t0</span><span style="color: #ff0000">]</span>.<span style="color: #ff0000">[</span><span style="color: #ff0000">LeaverId</span><span style="color: #ff0000">]</span>
登入後複製
Lambda
<span style="color: #000000">Blog_LeaveMsgs
.GroupBy (
a </span>=>
<span style="color: #0000ff">new</span><span style="color: #000000">
{
ReceiverId </span>=<span style="color: #000000"> a.ReceiverId,
LeaverId </span>=<span style="color: #000000"> a.LeaverId
}
)
.Select (
b </span>=>
<span style="color: #0000ff">new</span><span style="color: #000000">
{
接收人ID </span>=<span style="color: #000000"> b.Key.ReceiverId,
留言人ID </span>=<span style="color: #000000"> b.Key.LeaverId
}
)</span>登入後複製
5.distinct
查看留言表中的留言人人数
Linq to sql
(<span style="color: #0000ff">from</span> a <span style="color: #0000ff">in</span><span style="color: #000000"> Blog_LeaveMsgs </span><span style="color: #0000ff">select</span><span style="color: #000000"> a.LeaverId) .Distinct()</span>
登入後複製
sql
<span style="color: #0000ff">SELECT</span> <span style="color: #0000ff">DISTINCT</span> <span style="color: #ff0000">[</span><span style="color: #ff0000">t0</span><span style="color: #ff0000">]</span>.<span style="color: #ff0000">[</span><span style="color: #ff0000">LeaverId</span><span style="color: #ff0000">]</span> <span style="color: #0000ff">FROM</span> <span style="color: #ff0000">[</span><span style="color: #ff0000">Blog_LeaveMsg</span><span style="color: #ff0000">]</span> <span style="color: #0000ff">AS</span> <span style="color: #ff0000">[</span><span style="color: #ff0000">t0</span><span style="color: #ff0000">]</span>
登入後複製
Lambda
<span style="color: #000000">Blog_LeaveMsgs .Select (a </span>=><span style="color: #000000"> a.LeaverId) .Distinct ()</span>
登入後複製
6.子查询
查询留言数量超过4条的用户信息
Linq to sql
<span style="color: #0000ff">from</span> a <span style="color: #0000ff">in</span><span style="color: #000000"> Blog_Users </span><span style="color: #0000ff">where</span><span style="color: #000000"> (</span><span style="color: #0000ff">from</span> b <span style="color: #0000ff">in</span><span style="color: #000000"> Blog_LeaveMsgs group b by b.LeaverId into b </span><span style="color: #0000ff">where</span> b.Count()>=<span style="color: #800080">4</span> <span style="color: #0000ff">select</span><span style="color: #000000"> b.Key).Contains(a.UserId) </span><span style="color: #0000ff">select</span> a
登入後複製
sql
<span style="color: #008080">-- Region</span><span style="color: #008080"> Parameters</span>
<span style="color: #0000ff">DECLARE</span> <span style="color: #008000">@p0</span> <span style="color: #0000ff">Int</span> <span style="color: #808080">=</span> <span style="font-weight: bold; color: #800000">4</span>
<span style="color: #008080">-- EndRegion
</span><span style="color: #0000ff">SELECT</span> <span style="color: #ff0000">[</span><span style="color: #ff0000">t0</span><span style="color: #ff0000">]</span>.<span style="color: #ff0000">[</span><span style="color: #ff0000">UserId</span><span style="color: #ff0000">]</span>, <span style="color: #ff0000">[</span><span style="color: #ff0000">t0</span><span style="color: #ff0000">]</span>.<span style="color: #ff0000">[</span><span style="color: #ff0000">NickName</span><span style="color: #ff0000">]</span>, <span style="color: #ff0000">[</span><span style="color: #ff0000">t0</span><span style="color: #ff0000">]</span>.<span style="color: #ff0000">[</span><span style="color: #ff0000">CreateTime</span><span style="color: #ff0000">]</span>
<span style="color: #0000ff">FROM</span> <span style="color: #ff0000">[</span><span style="color: #ff0000">Blog_User</span><span style="color: #ff0000">]</span> <span style="color: #0000ff">AS</span> <span style="color: #ff0000">[</span><span style="color: #ff0000">t0</span><span style="color: #ff0000">]</span>
<span style="color: #0000ff">WHERE</span> <span style="color: #808080">EXISTS</span><span style="color: #000000">(
</span><span style="color: #0000ff">SELECT</span> <span style="color: #0000ff">NULL</span> <span style="color: #0000ff">AS</span> <span style="color: #ff0000">[</span><span style="color: #ff0000">EMPTY</span><span style="color: #ff0000">]</span>
<span style="color: #0000ff">FROM</span><span style="color: #000000"> (
</span><span style="color: #0000ff">SELECT</span> <span style="color: #ff00ff">COUNT</span>(<span style="color: #808080">*</span>) <span style="color: #0000ff">AS</span> <span style="color: #ff0000">[</span><span style="color: #ff0000">value</span><span style="color: #ff0000">]</span>, <span style="color: #ff0000">[</span><span style="color: #ff0000">t1</span><span style="color: #ff0000">]</span>.<span style="color: #ff0000">[</span><span style="color: #ff0000">LeaverId</span><span style="color: #ff0000">]</span>
<span style="color: #0000ff">FROM</span> <span style="color: #ff0000">[</span><span style="color: #ff0000">Blog_LeaveMsg</span><span style="color: #ff0000">]</span> <span style="color: #0000ff">AS</span> <span style="color: #ff0000">[</span><span style="color: #ff0000">t1</span><span style="color: #ff0000">]</span>
<span style="color: #0000ff">GROUP</span> <span style="color: #0000ff">BY</span> <span style="color: #ff0000">[</span><span style="color: #ff0000">t1</span><span style="color: #ff0000">]</span>.<span style="color: #ff0000">[</span><span style="color: #ff0000">LeaverId</span><span style="color: #ff0000">]</span><span style="color: #000000">
) </span><span style="color: #0000ff">AS</span> <span style="color: #ff0000">[</span><span style="color: #ff0000">t2</span><span style="color: #ff0000">]</span>
<span style="color: #0000ff">WHERE</span> (<span style="color: #ff0000">[</span><span style="color: #ff0000">t2</span><span style="color: #ff0000">]</span>.<span style="color: #ff0000">[</span><span style="color: #ff0000">LeaverId</span><span style="color: #ff0000">]</span> <span style="color: #808080">=</span> (<span style="color: #ff0000">[</span><span style="color: #ff0000">t0</span><span style="color: #ff0000">]</span>.<span style="color: #ff0000">[</span><span style="color: #ff0000">UserId</span><span style="color: #ff0000">]</span>)) <span style="color: #808080">AND</span> (<span style="color: #ff0000">[</span><span style="color: #ff0000">t2</span><span style="color: #ff0000">]</span>.<span style="color: #ff0000">[</span><span style="color: #ff0000">value</span><span style="color: #ff0000">]</span> <span style="color: #808080">>=</span> <span style="color: #008000">@p0</span><span style="color: #000000">)
)</span>登入後複製
Lambda
<span style="color: #000000">Blog_Users
.Where (
a </span>=><span style="color: #000000">
Blog_LeaveMsgs
.GroupBy (b </span>=><span style="color: #000000"> b.LeaverId)
.Where (b </span>=> (b.Count () >= <span style="color: #800080">4</span><span style="color: #000000">))
.Select (b </span>=><span style="color: #000000"> b.Key)
.Contains ((Int32</span>?<span style="color: #000000">)(a.UserId))
)</span>登入後複製
7.in操作
查询制定用户昵称的用户
Linq to sql
<span style="color: #0000ff">from</span> a <span style="color: #0000ff">in</span><span style="color: #000000"> Blog_Users
</span><span style="color: #0000ff">where</span> <span style="color: #0000ff">new</span> <span style="color: #0000ff">string</span>[]{<span style="color: #800000">"</span><span style="color: #800000">Kimisme</span><span style="color: #800000">"</span>,<span style="color: #800000">"</span><span style="color: #800000">FriendLee</span><span style="color: #800000">"</span><span style="color: #000000">}
.Contains(a.NickName)
</span><span style="color: #0000ff">select</span> a登入後複製
sql
<span style="color: #008080">-- Region</span><span style="color: #008080"> Parameters</span> <span style="color: #0000ff">DECLARE</span> <span style="color: #008000">@p0</span> <span style="color: #0000ff">NVarChar</span>(<span style="font-weight: bold; color: #800000">1000</span>) <span style="color: #808080">=</span> <span style="color: #ff0000">'</span><span style="color: #ff0000">Kimisme</span><span style="color: #ff0000">'</span> <span style="color: #0000ff">DECLARE</span> <span style="color: #008000">@p1</span> <span style="color: #0000ff">NVarChar</span>(<span style="font-weight: bold; color: #800000">1000</span>) <span style="color: #808080">=</span> <span style="color: #ff0000">'</span><span style="color: #ff0000">FriendLee</span><span style="color: #ff0000">'</span> <span style="color: #008080">-- EndRegion </span><span style="color: #0000ff">SELECT</span> <span style="color: #ff0000">[</span><span style="color: #ff0000">t0</span><span style="color: #ff0000">]</span>.<span style="color: #ff0000">[</span><span style="color: #ff0000">UserId</span><span style="color: #ff0000">]</span>, <span style="color: #ff0000">[</span><span style="color: #ff0000">t0</span><span style="color: #ff0000">]</span>.<span style="color: #ff0000">[</span><span style="color: #ff0000">NickName</span><span style="color: #ff0000">]</span>, <span style="color: #ff0000">[</span><span style="color: #ff0000">t0</span><span style="color: #ff0000">]</span>.<span style="color: #ff0000">[</span><span style="color: #ff0000">CreateTime</span><span style="color: #ff0000">]</span> <span style="color: #0000ff">FROM</span> <span style="color: #ff0000">[</span><span style="color: #ff0000">Blog_User</span><span style="color: #ff0000">]</span> <span style="color: #0000ff">AS</span> <span style="color: #ff0000">[</span><span style="color: #ff0000">t0</span><span style="color: #ff0000">]</span> <span style="color: #0000ff">WHERE</span> <span style="color: #ff0000">[</span><span style="color: #ff0000">t0</span><span style="color: #ff0000">]</span>.<span style="color: #ff0000">[</span><span style="color: #ff0000">NickName</span><span style="color: #ff0000">]</span> <span style="color: #808080">IN</span> (<span style="color: #008000">@p0</span>, <span style="color: #008000">@p1</span>)
登入後複製
Lambda
<span style="color: #000000">Blog_Users
.Where (a </span>=> <span style="color: #0000ff">new</span> String[] { <span style="color: #800000">"</span><span style="color: #800000">Kimisme</span><span style="color: #800000">"</span>, <span style="color: #800000">"</span><span style="color: #800000">FriendLee</span><span style="color: #800000">"</span> } .Contains (a.NickName))登入後複製
本網站聲明
本文內容由網友自願投稿，版權歸原作者所有。本站不承擔相應的法律責任。如發現涉嫌抄襲或侵權的內容，請聯絡admin@php.cn
熱AI工具
Undresser.AI Undress
人工智慧驅動的應用程序，用於創建逼真的裸體照片
AI Clothes Remover
用於從照片中去除衣服的線上人工智慧工具。
Undress AI Tool
免費脫衣圖片
Clothoff.io
AI脫衣器
AI Hentai Generator
免費產生 AI 無盡。
熱門文章
R.E.P.O.能量晶體解釋及其做什麼（黃色晶體）
3 週前
By 尊渡假赌尊渡假赌尊渡假赌
R.E.P.O.最佳圖形設置
3 週前
By 尊渡假赌尊渡假赌尊渡假赌
刺客信條陰影：貝殼謎語解決方案
2 週前
By DDD
R.E.P.O.如果您聽不到任何人，如何修復音頻
3 週前
By 尊渡假赌尊渡假赌尊渡假赌
WWE 2K25：如何解鎖Myrise中的所有內容
4 週前
By 尊渡假赌尊渡假赌尊渡假赌
熱工具
記事本++7.3.1
好用且免費的程式碼編輯器
SublimeText3漢化版
中文版，非常好用
禪工作室 13.0.1
強大的PHP整合開發環境
Dreamweaver CS6
視覺化網頁開發工具
SublimeText3 Mac版
神級程式碼編輯軟體(SublimeText3)
熱門話題
12306怎麼查詢歷史購票紀錄 查看歷史購票紀錄的方法
Mar 28, 2024 pm 03:11 PM
12306訂票app下載最新版是一款大家非常滿意的出行購票軟體，想去哪裡就去那裡非常方便，軟體內提供的票源非常多，只需要通過實名認證就能在線購票，所有用戶的出行車票機票都可以輕鬆買到，享受不同的優惠折扣。還能提前開啟預約搶票，預約飯店、專車接送都是可以的，有了它想去哪裡就去那裡一鍵購票，出行更加簡單方便，讓大家的出行體驗更舒服，現在小編在線詳細為12306用戶帶來查看歷史購票記錄的方法。 1.打開鐵路12306，點擊右下角我的，點擊我的訂單 2.在訂單頁面點擊已支付。 3.在已支付頁
學信網如何查詢自己的學歷
Mar 28, 2024 pm 04:31 PM
學信網如何查詢自己的學歷？在學信網中是可以查詢到自己的學歷，很多用戶都不知道如何在學信網中查詢到自己的學歷，接下來就是小編為用戶帶來的學信網查詢自己學歷方法圖文教程，感興趣的用戶快來一起看看吧！學信網使用教程學信網如何查詢自己的學歷一、學信網入口：https://www.chsi.com.cn/二、網站查詢：第一步：點選上方學信網位址，進入首頁點選【學歷查詢】；第二步：在最新的網頁中點選如下圖箭頭所示的【查詢】；第三步：之後在新頁面點選【的登陸學信檔案】；第四步：在登陸頁面輸入資料點選【登陸】；
一起學習word根號輸入方法
Mar 19, 2024 pm 08:52 PM
在word編輯文字內容時，有時會需要輸入公式符號。有的小夥子們不知道在word根號輸入的方法，小面就讓小編跟小夥伴們一起分享下word根號輸入的方法教學。希望對小夥伴們有幫助。首先，開啟電腦上的Word軟體，然後開啟要編輯的文件，並將遊標移到需要插入根號的位置，參考下方的圖片範例。 2.選擇【插入】，再選擇符號裡的【公式】。如下方圖片紅色圈的部分內容所示：3.接著選擇下方的【插入新公式】。如下方圖片紅色圈的部分內容所示：4.選擇【根式】，再選擇適當的根號。如下方圖片紅色圈的部分內容所示：
MySQL與PL/SQL的異同比較
Mar 16, 2024 am 11:15 AM
MySQL與PL/SQL是兩種不同的資料庫管理系統，分別代表了關係型資料庫和過程化語言的特性。本文將比較MySQL和PL/SQL的異同點，並附帶具體的程式碼範例進行說明。 MySQL是一種流行的關聯式資料庫管理系統，採用結構化查詢語言(SQL)來管理和操作資料庫。而PL/SQL是Oracle資料庫特有的過程化語言，用於編寫預存程序、觸發器和函數等資料庫物件。相同
三星S24ai功能詳細介紹
Jun 24, 2024 am 11:18 AM
2024是AI手机的元年，越来越多的手机集成了多项ai功能，通过ai智能技术的赋能，让我们的手机使用更加高效便捷。近日，年初发布的GalaxyS24系列再度提升了其生成式AI的体验，下面下详细的功能介绍，一起来看看吧。一、生成式AI深度赋能三星GalaxyS24系列通过GalaxyAI的赋能，带来了诸多智能化应用，这些功能与SamsungOneUI6.1深度集成，让用户可以随时获得便利的智能体验，显著提升了手机的使用效率和便捷性。由GalaxyS24系列首创的即圈即搜功能是亮点之一，用户只需长按
從零開始學習Go語言中的main函數
Mar 27, 2024 pm 05:03 PM
標題：從零開始學習Go語言中的main函數Go語言作為一種簡潔、高效的程式語言，備受開發者青睞。在Go語言中，main函數是一個入口函數，每個Go程式都必須包含main函數作為程式的入口點。本文將從零開始介紹如何學習Go語言中的main函數，並提供具體的程式碼範例。一、首先，我們需要安裝Go語言的開發環境。可前往官方網站（https://golang.org
什麼是狗狗幣
Apr 01, 2024 pm 04:46 PM
狗狗幣是一種基於網路迷因創建的加密貨幣，沒有固定的供應上限，交易時間快速，交易費用低，擁有龐大的迷因社群。用途包括小額交易、打賞和慈善捐贈。然而，其無限供應量、市場波動和作為笑話幣的地位也帶來風險和擔憂。什麼是狗狗幣？狗狗幣是一種基於網路迷因和笑話創建的加密貨幣。起源與歷史：2013年12月，兩位軟體工程師BillyMarkus和JacksonPalmer創立狗狗幣。靈感來自於當時流行的"Doge"模因，一個以一隻柴犬為特徵的滑稽照片加上破碎英語。特徵與優勢：無限供應量：與比特幣等其他加密貨
花亦山心之月鹿蜀技能屬性介紹
Mar 23, 2024 pm 05:30 PM
在花亦山心之月中鹿蜀是一名SSR名士，定位是單體後排，擁有很可觀的暴擊率，有不少玩家對鹿蜀還不太了解，下面小編就帶來了花亦山心之月鹿蜀技能屬性介紹，快來看看。名士屬性名士技能1、鹿鳴蜀中技能描述：鹿蜀出身蜀的窮奇會，自幼習武，武藝超群。對敵方後排單體造成攻擊力100%的普攻傷害，並降低目標10點怒氣。技能屬性：等級2：普攻傷害提升至105%。等級2：普攻傷害提升至110%，降低目標15點怒氣。等級2：普攻傷害提升至115%。等級2：普攻傷害提升至120%，降低目標20點怒氣。等級2：普攻
