Sort 84 Discussions, By:
Please Login in order to post a comment
Here is Oracle solution from my HackerrankPractice repository:
Feel free to ask if you have any questions :)
it says wrong answer when i initially typed this..
Please check it again. It works for all the versions of SQL
i am getting the insufficent privileges error
insufficent privileges error, is a bug?
Yes ! I have the same problem ..
I'm getting the same thing
same problem here guys....what to do.
it´s an error in your sintaxis.
Heraldo HackerRank Admin 2 years ago
We have fixed the issue. Apologies for the delay!
BRO ONLY TYPE-
SELECT * FROM CITY;
BECAUSE YOU HAVE TO DISPLAY TABLE IN THIS QUESTION .....
THIS IS WRON (SELECT * FROM CITY). YOU WERE ASKED TO SELECT EACH COLUMN IN A ROLL AND THIS IS HOW IT SHOULD BE DONE. SELECT ID,NAME,COUNTRYCODE,DISTRICT,POPULATION FROM CITY
BURN !!! lol
Both are same .here '*' refers to all .
i do thiz...
GRANT RESOURCE TO srun_uDFZN9eqOa error ?
I'm getting the same error too. Can't run anything.
Hi, it has been fixed sometime ago. Thanks for pointing here again.
SELECT * FROM CITY
SELECT ID,NAME,COUNTRYCODE,DISTRICT,POPULATION FROM CITY
MySQL Query is : SELECT * FROM CITY;
its an error in your syntax. correct syntax : select * from city
SELECT ID, NAME, COUNTRYCODE, DISTRICT, POPULATION FROM CITY;