we can simply write as SELECT* from customers WHERE age >=30 and age<=40; instead of writing all variable names after SELECT .right? | Sololearn: Learn to code for FREE!
New course! Every coder should learn Generative AI!
Try a free lesson
+ 4

we can simply write as SELECT* from customers WHERE age >=30 and age<=40; instead of writing all variable names after SELECT .right?

20th Sep 2016, 7:59 AM
karthik Y
karthik Y - avatar
14 Answers
+ 2
Yes... U can
27th Sep 2016, 7:26 PM
Savan Matariya
Savan Matariya - avatar
+ 2
yes you get the result between 30-40
15th Jan 2017, 7:01 AM
Abhishek Shukla
Abhishek Shukla - avatar
+ 1
نعم تستطيع
16th Nov 2016, 3:34 PM
Mostafa Mohammad
Mostafa Mohammad - avatar
+ 1
yeah that's fine but applicable only when u r using the whole table as per your select table content
23rd Nov 2016, 4:40 AM
Piyush Sharma
Piyush Sharma - avatar
0
Yes if you want to return all column from customers table with default column order
21st Sep 2016, 4:37 AM
Yohanes Jawa
Yohanes Jawa - avatar
0
By the above query u will get all column information data of customer table, whose age is in between 30 to 40 ( including 30 and 40 years)..
16th Nov 2016, 5:59 AM
shivanagaraj
0
yes you...can
16th Nov 2016, 3:31 PM
shashank singh Deshwal
shashank singh Deshwal - avatar
0
yes
18th Nov 2016, 11:05 AM
mary
0
yes
1st Dec 2016, 6:45 PM
Md.Sabir Ali
Md.Sabir Ali - avatar
0
yes you can, this is much better then that when you are willing to gain the data from the entire table, but if you wants to takes some specific data then you may use the concept of variables
22nd Jan 2017, 11:29 PM
mahendra mahajan
mahendra mahajan - avatar
- 1
yes
21st Sep 2016, 6:07 PM
manlio
- 1
j my own
1st Oct 2016, 9:55 PM
Louis Kpante
- 1
correct!
1st Oct 2016, 10:04 PM
Louis Kpante
- 2
j my own
1st Oct 2016, 9:55 PM
Louis Kpante