Skip to content

Instantly share code, notes, and snippets.

@reinink

reinink/nulls_last_tweet.html

Created September 24, 2019 15:24
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save reinink/ab4444dcc65c07664a257ce47fcb3d19 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save reinink/ab4444dcc65c07664a257ce47fcb3d19 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
nulls_last_tweet.html
<!DOCTYPE html>
<html>
<head>
<title>Nulls Last</title>
<meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
<link href="https://unpkg.com/tailwindcss@^1.0/dist/tailwind.min.css" rel="stylesheet">
</head>
<body class="antialiased leading-none">
<div class="flex w-full p-24 bg-gray-300">
<div class="w-full max-w-md mr-12">
<div class="text-xl text-gray-600">Before</div>
<div class="mt-4 bg-indigo-900 text-white px-6 py-6 rounded font-mono leading-snug">
<span class="text-pink-400">select</span> name, birth_date<br>
<span class="text-pink-400">from</span> users<br>
<span class="text-pink-400">order by</span> birth_date <span class="text-pink-400">desc</span>
</div>
<div class="mt-8 text-sm rounded bg-white shadow p-4">
<div class="flex border-b">
<div class="w-1/2 px-4 py-2 text-indigo-800 font-semibold">Name</div>
<div class="w-1/2 px-4 py-2 text-indigo-800 font-semibold">Birth Date</div>
</div>
<div class="flex border-b">
<div class="w-1/2 px-4 py-2">Elon Musk</div>
<div class="w-1/2 px-4 py-2 text-gray-600 font-mono">NULL</div>
</div>
<div class="flex border-b">
<div class="w-1/2 px-4 py-2">Mark Zuckerberg</div>
<div class="w-1/2 px-4 py-2 text-gray-600 font-mono">NULL</div>
</div>
<div class="flex border-b">
<div class="w-1/2 px-4 py-2">Jeff Bezos</div>
<div class="w-1/2 px-4 py-2">January 12, 1964</div>
</div>
<div class="flex border-b">
<div class="w-1/2 px-4 py-2">Tim Cook</div>
<div class="w-1/2 px-4 py-2">November 1, 1960</div>
</div>
<div class="flex border-b">
<div class="w-1/2 px-4 py-2">Bill Gates</div>
<div class="w-1/2 px-4 py-2">October 28, 1955</div>
</div>
<div class="flex">
<div class="w-1/2 px-4 py-2">Steve Jobs</div>
<div class="w-1/2 px-4 py-2">February 24, 1955</div>
</div>
</div>
</div>
<div class="w-full max-w-md">
<div class="text-xl text-gray-600">After</div>
<div class="mt-4 bg-indigo-900 text-white px-6 py-6 rounded font-mono leading-snug">
<span class="text-pink-400">select</span> name, birth_date<br>
<span class="text-pink-400">from</span> users<br>
<span class="text-pink-400">order by</span> birth_date <span class="text-pink-400">desc <span class="border-b text-yellow-300 border-yellow-300">nulls last</span></span>
</div>
<div class="mt-8 text-sm rounded bg-white shadow p-4">
<div class="flex border-b">
<div class="w-1/2 px-4 py-2 text-indigo-800 font-semibold">Name</div>
<div class="w-1/2 px-4 py-2 text-indigo-800 font-semibold">Birth Date</div>
</div>
<div class="flex border-b">
<div class="w-1/2 px-4 py-2">Jeff Bezos</div>
<div class="w-1/2 px-4 py-2">January 12, 1964</div>
</div>
<div class="flex border-b">
<div class="w-1/2 px-4 py-2">Tim Cook</div>
<div class="w-1/2 px-4 py-2">November 1, 1960</div>
</div>
<div class="flex border-b">
<div class="w-1/2 px-4 py-2">Bill Gates</div>
<div class="w-1/2 px-4 py-2">October 28, 1955</div>
</div>
<div class="flex border-b">
<div class="w-1/2 px-4 py-2">Steve Jobs</div>
<div class="w-1/2 px-4 py-2">February 24, 1955</div>
</div>
<div class="flex border-b">
<div class="w-1/2 px-4 py-2">Elon Musk</div>
<div class="w-1/2 px-4 py-2 text-gray-600 font-mono">NULL</div>
</div>
<div class="flex">
<div class="w-1/2 px-4 py-2">Mark Zuckerberg</div>
<div class="w-1/2 px-4 py-2 text-gray-600 font-mono">NULL</div>
</div>
</div>
</div>
</div>
</body>
</html>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment