+ 1

Write a query to sort out those customers with all information whose I'd value is within any of 3007,3008 and 3009

Sql

24th Jul 2019, 11:50 AM
Pauline
2 odpowiedzi
+ 6
Pauline are you using two tables or just one table for fetching the record in case you using two tables then you can use subquery with groupby and orderby or join SELECT * FROM customer WHERE customer_id IN (3007,3008,3009); Or SELECT * FROM CUSTOMER WHERE CUSTOMER_ID BETWEEN 3007 AND 3009;
24th Jul 2019, 12:06 PM
GAWEN STEASY
GAWEN STEASY - avatar
+ 2
Pauline It seems your question appears to be an assignment. Please show us your attempt and use the 8 rules to get help from the community. https://www.sololearn.com/Blog/38/8-simple-rules-to-get-help-from-the-community *can be a code coach solution which is meant for you to do to help you establish your skills abilities and where you need to learn... not the community *one issued by a school or other institution *one issued or created by another platform *one that appears to be in the form of a challenge that was created by you or somewhere else. Your question will be reviewed by a team of moderators and will most likely be marked for deletion. https://www.sololearn.com/Discuss/1316935/?ref=app
7th Feb 2021, 3:28 AM
BroFar
BroFar - avatar