Search a list of records: Difference between revisions
Content added Content deleted
(Added SQL implementation) |
(Added clarification) |
||
Line 2,819: | Line 2,819: | ||
Credits : This wouldn't have been possible without https://sqliteonline.com , you can create your own tables and run queries on them without installing your own DB. The queries below should work on most DBs but some like Access ( is that really a DB ? ) doesn't have LIMIT, or so I read. |
Credits : This wouldn't have been possible without https://sqliteonline.com , you can create your own tables and run queries on them without installing your own DB. The queries below should work on most DBs but some like Access ( is that really a DB ? ) doesn't have LIMIT, or so I read. |
||
But to get started, first we create the table : |
But to get started, first we create the table : |
||
PS : I realised after posting this implementation that not all cities in this list are capitals, well, it was a long day :P |
|||
<lang sql> |
<lang sql> |
||
Line 2,876: | Line 2,878: | ||
4.58 |
4.58 |
||
</pre> |
</pre> |
||
=={{header|Standard ML}}== |
=={{header|Standard ML}}== |
||