Couple problems on SQL - 244 and 245
source link: https://www.codeabbey.com/index/forum_topic/a883630e749e4d805c5dcf934fbd21b9
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
Couple problems on SQL - 244 and 245
Back to General discussions forum
Friends, Hi! Here are two first problems on SQL (and feel free to suggest more, since they are often encountered in interviews etc).
There easily could be flaws so feel free to tell about everything which looks suspicious to you.
Sorry for in-site sql runner is quite primitive, perhaps we'll decide to improve it in future.
P.S. I feel that though logically more complex, the second problem may be easier than the first, sorry for that.
Are we supposed to use only 1 select?
yep, honestly I'm not sure how are you going to combine two selects :) though you can use union
probably if you want
two.
thanks for hint, I'll add the note to problem statement.
on a single select statement
oops, sorry for this - I'll try to check what may be wrong with it and come back soon
UPD curious thing - it is substring
function. it is not recognized by SQLite on server but seems to be ok for
SQLite in the web-page. I guess, replace it with substr
.
I shall try appending error text if any to error message.
Recommend
About Joyk
Aggregate valuable and interesting links.
Joyk means Joy of geeK