Use of ALL operator in SQL Server

Amatya
Posted by Amatya under Sql Server category on | Points: 40 | Views : 585
Use of ALL operator in SQL Server

SELECT
*
FROM
tblDNF
WHERE
NOT ID >= ALL (SELECT PID FROM tblDNF)


The above query reveals that there aresome ID whose value is lower than PID.

Thanks
Amatya

Comments or Responses

Login to post response