首页 \ 问答 \ 存储过程计数在计数中具有ID号的行数(Stored procedure count number of rows with id numbers in the count)

存储过程计数在计数中具有ID号的行数(Stored procedure count number of rows with id numbers in the count)

 我想要计算带有ID的索赔总数。  
SELECT   
    InsuranceId,Name,
    COUNT(claimid) AS TotalPendingClaims
FROM 
    Claim 
GROUP BY
    InsuranceId
 
 这是我的查询，但我想获得在上述查询中计算的claimid 。 我需要列claimIds=(1,2,4,5)  
 预期结果：  
InsuranceId  Name TotalPendingClaims  ClaimIds
-----------------------------------------------
1            Med     2                  23,24
2            TX      1                   55
3            TED     3                  44,45,46

I want to get count total numbers of claims with the ID. 
SELECT   
    InsuranceId,Name,
    COUNT(claimid) AS TotalPendingClaims
FROM 
    Claim 
GROUP BY
    InsuranceId
 
This is my query, but I want to get claimid also which is counted in the above query. I need column claimIds=(1,2,4,5) 
Expected result: 
InsuranceId  Name TotalPendingClaims  ClaimIds
-----------------------------------------------
1            Med     2                  23,24
2            TX      1                   55
3            TED     3                  44,45,46

原文：https://stackoverflow.com/questions/47785520

更新时间：2023-07-06 20:07

最满意答案

 当使用Laravel提供的LoginController类时，它会检查：  
protected function attemptLogin(Request $request)
{
    return $this->guard()->attempt(
        $this->credentials($request), $request->has('remember')
    );
}
 
 只需在您的请求中加入“ remember ”，即可记住用户登录信息。 

When using the LoginController class provided by Laravel, it does this check: 
protected function attemptLogin(Request $request)
{
    return $this->guard()->attempt(
        $this->credentials($request), $request->has('remember')
    );
}
 
Simply include 'remember' to your request, to remember the user login.

存储过程计数在计数中具有ID号的行数(Stored procedure count number of rows with id numbers in the count)

最满意答案

相关问答

通过本地客户端程序获取服务器mysql数据库信息[2023-04-27]

Laravel 5.2 ajax登录(Laravel 5.2 ajax login)[2022-03-02]

Laravel 4：使用Auth :: login登录时如何记住用户(Laravel 4: how to remember a user when logging him in using Auth::login)[2023-04-06]

laravel记住我不工作(laravel remember me not working)[2022-06-24]

奇怪的ajax记得我登录bug(Weird ajax remember me login bug)[2022-05-19]

Laravel：使用和不使用Remember Me选项登录的区别？(Laravel: difference between login with and without Remember Me option?)[2022-07-28]

Laravel 500内部错误（AJAX jQuery登录）(Laravel 500 Internal Error (AJAX jQuery Login))[2022-07-08]

设置记住ajax laravel登录(Setting remember on ajax laravel login)[2022-05-03]

Laravel Ajax登录(Laravel Ajax Login)[2021-10-18]

Laravel Ajax登录尝试重定向(Laravel Ajax Login Tries To Redirect)[2022-09-21]

相关文章

最新问答