- 20

Can anyone help me in SQL 'cake' project.

SELECT *FROM cakes table; ORDER BY minimal calories;LIMIT 3;

24th Dec 2020, 9:23 AM
คгשเภ๔ кย๓คг
คгשเภ๔ кย๓คг - avatar
14 Réponses
- 14
Arvind Kumar , change your query => SELECT * FROM cakes ORDER BY calories LIMIT 3;
24th Dec 2020, 10:33 AM
TheWh¡teCat 🇧🇬
TheWh¡teCat 🇧🇬 - avatar
+ 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?
30th Apr 2021, 5:10 PM
Jason J
Jason J - avatar
+ 7
SELECT name,calories from cakes ORDER by calories LIMIT 3;
25th Sep 2021, 3:51 AM
Sandhya.v
Sandhya.v - avatar
+ 1
Select InitCap(name) as name, calories from cakes order by calories limit 3
1st May 2021, 4:34 PM
Jillian Welkom
Jillian Welkom - avatar
+ 1
SELECT * FROM cakes ORDER BY calories LIMIT 3;
5th Jul 2022, 5:49 AM
Santiago Porras Jaramillo
Santiago Porras Jaramillo - avatar
19th Jan 2021, 1:11 PM
คгשเภ๔ кย๓คг
คгשเภ๔ кย๓คг - avatar
0
SELECT * FROM cakes ORDER BY calories LIMIT 3; write this only
23rd Apr 2021, 9:18 AM
Anshuman Raj
Anshuman Raj - avatar
0
select * from cakes order by calories asc limit 3;
29th Aug 2021, 8:16 AM
Sarath Chandra Reddy
Sarath Chandra Reddy - avatar
0
SELECT * FROM cakes ORDER BY calories LIMIT 3; working
23rd Dec 2021, 6:02 AM
Karthik M P
Karthik M P - avatar
- 1
SELECT * FROM CAKES ORDER BY CALORIES LIMIT 3
30th Mar 2021, 9:40 AM
Kishanraj permukha
Kishanraj permukha - avatar
- 2
SELECT * FROM cakes ORDER BY calories LIMIT 3;
15th Apr 2022, 8:00 PM
RAWTiON™
RAWTiON™ - avatar
- 3
it's working now!
15th Feb 2021, 5:56 PM
Ricardo Rodriguez
Ricardo Rodriguez - avatar
- 3
SELECT * FROM cakes ORDER BY calories LIMIT 3;
25th Apr 2021, 1:20 PM
Md. Rakibul Islam
Md. Rakibul Islam - avatar
- 5
Not working
12th Feb 2021, 11:31 PM
Godwin Rangson
Godwin  Rangson - avatar