23
webdev
5y

kinda coding i guess, company specialising in making statistics for other companies, analytic stuff or such, wanted stack: php, mysql

Interviewer: so here is our tech guy, who will be your boss if... so he would like to ask a few questions
techGuy: how would you ask for all the rows in a table? * looks at me *
Interviewer: * looks at me too *
me (learning inner, outer, left, right joins and transactions yesterday): * am i a joke to you? *
also me: * they must be making fun of me or something * well the query should be SELECT * FROM tableName; but one should really not use that, as * in theory really slows things down, because it loads unnecessary meta data bla bla
they: * look at each other * You're really good young man! Yes of course we know that, haha!
Interviewer: You said you just finished Uni, you doesn't seem like a junior to me! good job!
techGuy: so how would you LIMIT your results to 100 rows?
me: sigh * looks at door without turning head, so they wont notice *

Comments
  • 13
    btw they called after 2 weeks and I was hired lol but I turned them down for my current job of 4 years
  • 2
  • 3
    lol, database 101
  • 2
    I just got 55/100 on a beginners knowledge test for SQL that included questions like: which statement would run faster, which statement would return an error,and so on.

    What you were asked is what I was expecting for begrimed shit, what I got is mid range knowledge in my opinion 😃
Add Comment