CODEWITHSUNDEEP
sql
Deepak Kumar
Deepak Kumar

Reputation: 682

Sql query result

what would be the result of following query?

select StudentName from Students where StudentName LIKE '[^R-X]%'

select StudentName from Students where StudentName = '[^R-X]%

thanks

Upvotes: 1

Views: 66

Answers (2)

juergen d
juergen d

Reputation: 204766

All Students who's name is not starting with R,S,T,U,V,W or X

The difference between the 2 queries is that the first is correct and the second not. You can use wildcards (%) only with the like operator.

Upvotes: 2

Andre Gross
Andre Gross

Reputation: 263

All Studunts, which Studentname not begins with r,s,t,u,v,w or x.

Upvotes: 0

Related Questions