SQL Server Error in Select multi Column from Subquery

x6492ojm 于 2023-10-15 发布在其他

关注(0)|答案(1)|浏览(106)

I wrote following SQL command

select * from [Monitoring].[dbo].[MaintTaskMonitor]  
where (JobStartDate,TaskType) in (
select max(JobStartDate),TaskType  from [Monitoring].[dbo].[MaintTaskMonitor]  where systemname='Dido'
group by TaskType)

which gave the following error:

An expression of non-boolean type specified in a context where a condition is expected, near ','.

Where is the problem from?

sql-server

来源：https://stackoverflow.com/questions/77172736/error-in-select-multi-column-from-subquery

1条答案

按热度按时间

mgdq6dx11#

You could, instead, switch to a correlated subquery and then check the value of JobStartDate from the outer scope matches the MAX value of the inner scope in the HAVING :

USE Monitoring; --Connect to the correct database instead, no need for 3 part naming
GO

SELECT <Explicit Column List> --Get out of the habit of using *
FROM [dbo].[MaintTaskMonitor] MTM
WHERE EXISTS (SELECT 1
              FROM [dbo].[MaintTaskMonitor] sq
              WHERE sq.systemname = 'Dido'
                AND sq.TaskType = MTM.TaskType
              HAVING MAX(sq.JobStartDate) = MTM.JobStartDate);

赞(0）回复(0）举报 2023-10-15

我来回答

SQL Server Error in Select multi Column from Subquery

1条答案

相关问题

热门标签

最新问答