select cl_to, page_title
from page
join categorylinks on page_id =... |
3 years ago |
select page_title
from page
join categorylinks on page_id = cl_from
where... |
3 years ago |
select * from categorylinks where cl_to = 'Analytical_chemistry' |
3 years ago |
select * from categorylinks limit 5 |
3 years ago |
select * from page limit 2 |
3 years ago |
select * from page where rownum < 2 |
3 years ago |
select * from page where page_namespace = 48252 |
3 years ago |
select * from categorylinks where cl_from = 48252 |
3 years ago |
select * from categorylinks where cl_from = 48252 |
3 years ago |
select * from categorylinks where cl_to = 'Analytical_Chemistry' |
3 years ago |
select * from category where cat_title like '%chemistry%' |
3 years ago |
describe category |
3 years ago |
select * from all_tab_columns |
3 years ago |
select * from all_tables |
3 years ago |