account
challenge
contact
credit
hacker
links
stat
todo
wtf

Top Hackers
alucardo 354 points 100.00%
saiwa 354 points 100.00%
thefinder 354 points 100.00%
Anonr 350 points 98.87%
neoxquick 344 points 97.18%
tehron 335 points 94.63%
livinskull 330 points 93.22%
Akorlith 325 points 91.81%
rubiya 323 points 91.24%
madbat2 320 points 90.40%

New Hackers
hylax : A different method
deuterium : A different method
Blizziix : What's that say? I
test - : Inserted
aa : Inserted
1 - : Inserted

Partner Sites
Halls of Valhalla
Additional Challenge Sites
SPOJ with 6739 challenges.
HackThis!! with 55 challenges.
Omega Project with 7 challenges.
Root-Me with 1203 challenges.
Rankk with 345 challenges.
Updated on 04/09/20 2:46:03 AM UTC
It's only a game!

Research harder

Adjoined

You have three tables in a PostgreSQL database.
  • users
  • roles
  • user_roles
Produce a query that prints out each users name, password and role.
Sort ascending by user name.
The columns in your ResultSet MUST be named exactly, in this order:
  • Name
  • Password
  • Role


Good Luck!
Enter your query below and click submit.




Who's beaten this one?
Pseudo
  Pass

There are currently 90 challenges, with a maximum possible value of 354 points.

New Challenges
Rumplestiltskin
Unusual Translation
Hashed II
Beep Beep
JSON and the Argonauts III
JSON and the Argonauts II
JSON and the Argonauts I

Most Popular Challenges
What's that say? I
A curious escape
Computer Talk
Base 8^2
What's that say? III
I came, I saw, I encrypted
What goes there?

14 hackers solved 14 challenges this week
Inserted by aaaor =
Inserted by or = -
Inserted by or = limit 0,1 -
Inserted by /xml(0,(0xa,version()),0)
Inserted by -xml(0,(0xa,version()),0)
Inserted by -(select 1 union select 2) -
Inserted by 1 -
Inserted by aa
Inserted by rubiya
Inserted by test -
Parse it fast by occasus
What's that say? I by Blizziix
A different method by deuterium
A different method by hylax

View more stats

Member of The Internet Defense League

Care and feeding instructions