Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
range and pattern matching
create table student(id integer,name varchar(30),marks integer,primary key(id)); insert into student values(1,'aaliya',80),(2,'sona',50),(3,'jay',34),(5,'raj',91); select * from student; select * from student where id between 1 and 3; select * from student where marks not between 36 and 100; select * from student where name like 'a%' ; select * from student where name not like '_a%' ;
run
|
edit
|
history
|
help
0
Rno 37 boat
for xml path concatenation ordered by seqno
Conditional Operator (IIF)
reee
practice sql_12AUG
performance on update using subquery versus correlated update
food_plan
test22
№1
COMPUTED COLUMN