Output always column name.

Select name From films Where year >= 2010 And (production= ‘marvel studios’) Order by name; Output always comes out with just the column name “name”. What am I doing wrong?

26th Mar 2021, 11:55 AM
Brett Bilbrey
Brett Bilbrey - avatar
7 ответов
Thanks for the prompt response! what I meant was I want the names in the column that follow that specific guidline, but the output is literally just “name” I want the actually names under the “name” column.
26th Mar 2021, 12:01 PM
Brett Bilbrey
Brett Bilbrey - avatar
i have the same issue
13th Jan 2022, 3:08 PM
Gayane Avanesyan
Gayane Avanesyan - avatar
Select name From films Where year >= 2010 And (production = ‘Marvel Studios’) Order by name; take note of the Character in 'Marvel Studio' herein lies your bug
10th Nov 2022, 10:12 AM
Taiwo Oluwatobi
Taiwo Oluwatobi - avatar
Is somebody have code which will work?
25th Jan 2023, 1:03 AM
Milena Szczubełek
Milena Szczubełek - avatar
- 1
This has been broken that long. I’m getting the same thing even though i have the correct answer.
11th Jan 2022, 12:29 AM
Tyrone Nicholas
- 1
select name,year from films where production IN('Marvel Studios') and year >= 2010 order by year
25th Dec 2022, 4:01 PM
Romit Katrodiya
Romit Katrodiya - avatar
- 3
You are only selecting the name column in your select clause. To select all columns do this: SELECT * FROM .....
26th Mar 2021, 11:58 AM