Jump to content

Any and All keywords


charuswapna
 Share

Recommended Posts

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.

Link to comment
Share on other sites

  • 5 weeks later...

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.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...