Results for “ORDER BY”
Small, practical examples. Search by task or narrow things down below.
Print only duplicate values
Linux Commands: Use uniq -d after sorting to report each repeated value once.
Linux Commands✓ Tested
Print only the matching portions
Linux Commands: Use extended regex and -o to extract digit sequences.
Linux Commands✓ Tested
Print separate arguments safely
Linux Commands: Print separate arguments safely using GNU/Linux commands in an empty practice directory.
Linux Commands✓ Tested
Print the final lines of a file
Linux Commands: Use tail -n for a fixed-size suffix of a log.
Linux Commands✓ Tested
Process a FIFO queue
C#: Queue removes elements in the order they were enqueued.
C#✓ Tested
Quote a CSV field and double embedded quotes
C: A quoted CSV field represents a quote character by repeating it.
C✓ Tested
Rank tied scores without gaps
SQL: DENSE_RANK assigns equal ranks to ties and increments by one for the next distinct score.
SQL✓ Tested
Rank tied scores without gaps
SQL Server: DENSE_RANK assigns equal ranks to ties and increments by one for the next distinct score.
SQL Server✓ Tested
Rank tied scores without gaps
Postgres: DENSE_RANK assigns equal ranks to ties and increments by one for the next distinct score.
Postgres✓ Tested
Rank tied scores without gaps
SQLite: DENSE_RANK assigns equal ranks to ties and increments by one for the next distinct score.
SQLite✓ Tested
Read a file from the latest commit
Git: Read a file from the latest commit inside the disposable repository created by the input setup.
Git✓ Tested
Read an ISO week date
Linux Commands: Use ISO week year, week number, and weekday directives together.
Linux Commands✓ Tested