Sort 79 Discussions, By:
Please Login in order to post a comment
Kinda feels like this challenge is out of place. (It's much easier than most of the ones before it.)
I also feel same, maybe hackerrank needs "Very easy" mode for problems...
It does feel out of place, however maybe its to show that not all queries have to be complex (well not too much in this case), some can be simple, throwing people off? - Feels weird replying to a 2 year old comment!
SELECT NAME FROM EMPLOYEE
order by NAME;
even i did the same, its showing the output in alphabetical order but still its showing test case not passed.
CAn you show your querry please.
write everything in capital letter
it's one line and it is correct :)
select name from Employee order by name asc;
SOLUTION IN MYSQL...
select name from employee order by name;
Let me know if you have any questions!
ORDER BY Name;
(From my HackerRank repo on GitHub.)
select name from Employee
order by name;
select name from employee
order by name asc;
SELECT name FROM employee
ORDER BY name;
SELECT name from employee order by name ;
ASc is not required because by default it takes ascending order if we need descending then we need to mention as descending 'desc'.
select name from Employee order by name;