7 kyu
SQL Basics: Repeat and Reverse
10,785 of 10,787PG1
Loading description...
Fundamentals
SQL
.avif)
This comment has been reported as {{ abuseKindText }}.
Show
This comment has been hidden. You can view it now .
This comment can not be viewed.
- |
- Reply
- Edit
- View Solution
- Expand 1 Reply Expand {{ comments?.length }} replies
- Collapse
- Spoiler
- Remove
- Remove comment & replies
- Report
{{ fetchSolutionsError }}
-
-
Your rendered github-flavored markdown will appear here.
-
Label this discussion...
-
No Label
Keep the comment unlabeled if none of the below applies.
-
Issue
Use the issue label when reporting problems with the kata.
Be sure to explain the problem clearly and include the steps to reproduce. -
Suggestion
Use the suggestion label if you have feedback on how this kata can be improved.
-
Question
Use the question label if you have questions and/or need help solving the kata.
Don't forget to mention the language you're using, and mark as having spoiler if you include your solution.
-
No Label
- Cancel
Commenting is not allowed on this discussion
You cannot view this solution
There is no solution to show
Please sign in or sign up to leave a comment.
walk in the park
It shouldn't be 7kyu. I think it's 8.
Tests are incomplete.
My results table had the original string repeated 3 times, but not reversed and I solved it correctly. Why ask for the reverse string if it's not required (and may even be incorrect)?
The question contains no clues about the order of resulting table. How you expect this to solve?!
Please, the person who made this Kata takes a time to review the question because it is hard to understand what's asked to do. If you could, put a example in the question
You gotta make a better explanation of what must be done or at least give an example of the expected result. Thanks for the Kata.
You should better explain the question, it is understood that a table must be created, so when using "create table as ..." it fails
This doens't work with REPLICATE, but works with REPLACE, which is from MySQL and not MS SQL. What the actual fuck?
The only SQL version you can select is PostgreSQL so... not an issue.
Why function REPLICATE(name, 3) does not work for this query?
Because that's not PostgreSQL
I would say this was poorly described. Take a minute to explain your question better please as this very simple problem presented its self as one that didnt make a lot of sense at first. I had to pull out the expected results to dechipher what was being asked
This comment has been hidden.