Selecting Multiple Columns in SQL | Sololearn: Learn to code for FREE!

+1

Selecting Multiple Columns in SQL

I Have been solving the sololearn sql chalanges in the lessons the question was Select multiple columns from products table and here is what I tried so far but it didn't work is there something wrong inside my query: SELECT ProductName,ProductionDate, ExpirationDate FROM Products;

5/1/2021 3:02:33 PM

Abdalla Moha

17 Answers

New Answer

+5

I can see that you are at this lesson: https://www.sololearn.com/learn/SQL/1852/ I am going to try now, will be back in 1 sec. It is case sensitive when comparing output. https://www.sololearn.com/post/1064943/?ref=app I'll write to SoloLearn to report this. Thanks for your question.

+2

Abdalla Moha there is no error in your code . i am also facing the problem . We can't do code coaches of sql right now due to a bug.

+1

Gordon you re welcome thanks for the reporting.

+1

Same here. Same input as Abdalla. Getting a “No Input” error message - results returned in lowercase. Also getting the same error message for the end module exercise!

+1

You can use the InitCap() function. It worked for me. It’s a workaround until the bugs are squashed😀 https://oraclesql.in/initcap/

+1

Abdalla Moha yes it works: SELECT InitCap(ProductName) as ProductName , ProductionDate, ExpirationDate FROM Products

+1

No sir - it does! I used it to solve both the ‘Multiple Columns’ and ‘Cakes’ excersises in the Sololearn editor!

+1

The problem is still there on my side

0

Md Sayed thanks man i hope it will be fixed soon.

0

Same problem here 👍

0

Shawn Blackman thanks man initcap function is not working inside sololearn editor I think it's for oracle not mysql sololearn uses mysql database.

0

Jozef Šulej👍🏾🍷

0

Jozef Šulej it worked for me at last thank you so much

0

Shawn Blackman i solved the 'Multiple Columns' now I'm heading to the 'Cakes' thanks for the help it means alot to me.

0

Abdalla Moha 👍🏾👍🏾👍🏾

0

Have you tried to do that? SELECT ProductName, ProductionDate, ExparitonDate FROM Products;

0

Control a