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
new problem SQL
DETAILS
Terceiro
Task_3_Final
Window Functions - ROW_NUMBER()
SQL basics(Data Definition Language)
manish
Common Table Expression
/Users/svetlanakanevskaa/Downloads/ACDB.sql
Stored procedure