- 20
Can anyone help me in SQL 'cake' project.
SELECT *FROM cakes table; ORDER BY minimal calories;LIMIT 3;
14 Réponses
- 14
Arvind Kumar , change your query => SELECT * FROM cakes
ORDER BY calories LIMIT 3;
+ 7
When you input:
SELECT * FROM cakes ORDER BY calories LIMIT 3;
it ouputs:
name,calories
opera cake,90
sponge cake,100
apple cake,100
and calls it wrong, seems like the table lists the cakes with lower case letters?
+ 7
SELECT name,calories from cakes ORDER by calories LIMIT 3;
+ 1
Select InitCap(name) as name, calories from cakes order by calories limit 3
+ 1
SELECT * FROM cakes ORDER BY calories LIMIT 3;
0
TheWh¡teCat 🇧🇬 thank you
0
SELECT * FROM cakes ORDER BY calories LIMIT 3;
write this only
0
select * from cakes order by calories asc limit 3;
0
SELECT * FROM cakes ORDER BY calories LIMIT 3;
working
- 1
SELECT * FROM CAKES ORDER BY CALORIES LIMIT 3
- 2
SELECT * FROM cakes ORDER BY calories LIMIT 3;
- 3
it's working now!
- 3
SELECT * FROM cakes ORDER BY calories LIMIT 3;
- 5
Not working