Skip to content

Instantly share code, notes, and snippets.

@meki

meki/AOJ_0001_List_of_Top_3_Hills.sql

Last active August 29, 2015 13:55
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save meki/8767220 to your computer and use it in GitHub Desktop.
Save meki/8767220 to your computer and use it in GitHub Desktop.
Download ZIP
AOJ_0001_SQL
Raw
AOJ_0001_List_of_Top_3_Hills.sql
-- テーブルの作成
create table tbl(height integer);
-- テキストファイルからデータを読み込む
.import data.txt tbl
-- 'tbl' から 'height' フィールドで降順ソートして 3 行読み込む
select * from tbl order by height desc limit 3;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment