Search
 
SCRIPT & CODE EXAMPLE
 

SQL

Find the names of sailors who have reserved a red boat, and list in the order of age

select s.name, s.age
from sailors s, reserves r, boats b
where s.id = r.sId and r.bId = b.id and b.color = 'red'
order by s.age;
Comment

PREVIOUS NEXT
Code Example
Sql :: mysql calcular idade 
Sql :: merge command in sql 
Sql :: difference between left outer join and left join in sql 
Sql :: mysql select smaller of two values 
Sql :: psql invalid command N 
Sql :: REMOVE DATE FROM DATE TIME SQL SERVER 
Sql :: mysql not 
Sql :: example database query 
Sql :: postgres insert new row advance count 
Sql :: select top values sql 
Sql :: php select data from mysql database without column name 
Sql :: Ms Sql set us timezone 
Sql :: foreign key sql 
Sql :: postgres disable foreign keys 
Sql :: wp_query raw sql 
Sql :: mysql large import 
Sql :: sql date before 
Sql :: sql ssrs 
Sql :: Deleting data from tables 
Sql :: SQL JOIN and Aliases 
Sql :: google sheets data validation custom formula filter 
Sql :: sql insert all 
Sql :: migrations.RunSQL 
Sql :: what is ssrs and ssis in sql server 
Sql :: sql limit 
Sql :: on delete set default 
Sql :: sqlite dropping multiple tables 
Sql :: sql on-premises 
Sql :: sintaxis SELECT sql 
Sql :: SQL authentication error 
ADD CONTENT
Topic
Content
Source link
Name
7+8 =