Sub query returns more than 1 row
255
June 18, 2017, at 6:40 PM
My web site is a cafeteria, user login and ordering ... When the same user logs in twice, the sub query error appears. What are the possible ways to solve the sub query problem?
Answer 1
if your subquery return more then a row
you can use a in clause if your manage more rows
select * from my_table
where id in (select id from table2 where ....)
or obtain asingle result eg: using aggregation function
select * from my_table
where id = (select max(id) from table2 where ....)
-
05:30
-
04:00
-
00:00
-
10:30
-
9:10
-
07:40
Firebase Cloud Functions: PubSub, "res.on is not a function"
-
04:00
TypeError: Cannot read properties of undefined (reading 'createMessageComponentCollector')
-
9:20
-
7:40
POPULAR ONLINE
- typescript: tsc is not recognized as an internal or external command, operable program or batch file 111368 visits
- search for elements in a list 111047 visits
- In Chrome 55, prevent showing Download button for HTML 5 video 98808 visits
- RxJS5 - error - TypeError: You provided an invalid object where a stream was expected 96306 visits
- Ionic 2 - how to make ion-button with icon and text on two lines? 92498 visits
- NetBeans IDE - ClassNotFoundException: net.ucanaccess.jdbc.UcanaccessDriver 62020 visits
- Adding methods to es6 child class 22362 visits
