Any and All keywords

[charuswapna]

Iam using DB browser for SQLite and it was working fine. I started using 'ALL' and 'ANY' operators and suddenly am getting error.

"Execution finished with errors.

Result: near "select": syntax error

At line 5:

Select cName

from College S1"

This is the error am getting. Please help. AM completely new to SQL and it is all confusing.

[dsonesuk]

Its probably the space in the column name, try backticks ( ` ) around column name.

[Makwana Prahlad]

Hello, @charuswapna

Please try this query ,To Any and All keywords

Syntax of Any:

 

SELECT column-names

FROM table-name

WHERE column-name operator ANY

(SELECT column-name

FROM table-name

WHERE condition)

 Syntax of All:

SELECT column-names

FROM table-name

WHERE column-name operator ALL

(SELECT column-name

FROM table-name

WHERE condition)

I hope this query will be useful.

Thank you.