hey , can we fire query like FROM customer SELECT city ?? Instead if SELECT city FROM coustomer | Sololearn: Learn to code for FREE!
New course! Every coder should learn Generative AI!
Try a free lesson
0

hey , can we fire query like FROM customer SELECT city ?? Instead if SELECT city FROM coustomer

26th Jun 2018, 5:56 PM
Prathamesh Patkar
Prathamesh Patkar - avatar
5 Answers
+ 21
No, it will produce an error.
26th Jun 2018, 6:01 PM
Igor Makarsky
Igor Makarsky - avatar
+ 1
No. SQL is case insensitive, but you still have to keep correct syntax.
26th Jun 2018, 6:21 PM
Jan Štěch
Jan Štěch - avatar
+ 1
yes... as long as the naming/calling of either columns and table are correct using the right syntax...
26th Jun 2018, 9:20 PM
Silvanus Justice Silvanus
Silvanus Justice Silvanus - avatar
0
sql is like English so you have to make clearer what you want to do with this query like you mentioned select city from customers
26th Jun 2018, 6:41 PM
MsJ
MsJ - avatar
- 1
but SELECT city FROM Customer looks odd and this looks sense 😁 FROM customer SELECT city
26th Jun 2018, 6:55 PM
Prathamesh Patkar
Prathamesh Patkar - avatar