+ 4
we can simply write as SELECT* from customers WHERE age >=30 and age<=40; instead of writing all variable names after SELECT .right?
14 Respuestas
+ 2
Yes... U can
+ 2
yes you get the result between 30-40
+ 1
نعم تستطيع
+ 1
yeah that's fine but applicable only when u r using the whole table as per your select table content
0
Yes if you want to return all column from customers table with default column order
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)..
0
yes you...can
0
yes
0
yes
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
- 1
yes
- 1
j my own
- 1
correct!
- 2
j my own