問題描述

使用此語句:

select * from qvalues where rowid ,name,compound in (
    select rowid,name,compound from qvalues where rowid in (select rowid from batchinfo where instrument='tf1')
    group by rowid,name,compound
    having COUNT(*)>1 
    )
    group by rowid,name,compound
having rid=min(rid)

出現(xiàn)這個錯誤:

消息 4145，級別 15，狀態(tài) 1，第 3 行在預期條件的上下文中指定的非布爾類型的表達式，靠近 ','.Msg 156, Level 15, State 1, Line 8關鍵字group"附近的語法不正確.

Msg 4145, Level 15, State 1, Line 3 An expression of non-boolean type specified in a context where a condition is expected, near ','. Msg 156, Level 15, State 1, Line 8 Incorrect syntax near the keyword 'group'.

這個SQL語句有什么問題?我需要在 have min(rid) 表中找到這三個字段的所有出現(xiàn).

What is wrong with this SQL statement? I need to find all the occurrences of those three fields in the table having min(rid).

更新使用此查詢，外部選擇不起作用.我做錯了什么?

Update Using this query, the outer select is not working. What am I doing wrong?

select * from qvalues where rid not in (
select q.rowid, q.name, q.compound, min(q.rid)
    from qvalues q
        inner join batchinfo b
            on q.rowid = b.rowid
                and b.instrument = 'tf1'
    group by q.rowid, q.name, q.compound
    having count(*) > 1)

推薦答案

我認為這與您要實現(xiàn)的目標相同.

I think this is equivalent to what you're trying to achieve.

select min(q.rid)
    from qvalues q
        inner join batchinfo b
            on q.rowid = b.rowid
                and b.instrument = 'tf1'
    group by q.rowid, q.name, q.compound
    having count(*) > 1

這篇關于非布爾類型的表達的文章就介紹到這了，希望我們推薦的答案對大家有所幫助，也希望大家多多支持html5模板網(wǎng)！