Learn, Share, Build
302
September 20, 2017, at 1:32 PM
Table1:
id name | design | AddrId
1 Ram SE 101
2 Ravi JSE 102
3 Vas SSE 103
Table2:
AddrId | MobNo | EmailId
101 78945 a@gmail
101 54675 b@gmail
102 12345 c@gmail
103 45687 d@gmail
103 64587 d@gmail
output
AddrId | MobNo | EmailId
101 54675 b@gmail
102 12345 c@gmail
103 64587 d@gmail
Answer 1
There are no details, so here a general response:
SELECT DISTINCT col1, col2, col3 FROM table [WHERE a = 123] ;
SELECT col1, col2, col3 FROM table [WHERE a = 123] GROUP BY col1[, col2] ;
Answer 2
You can use MIN aggregate function with GROUP BY.
Query
select `AddrId`,
min(`MobNo`) as `MobNo`,
min(`EmailId`) as `EmailId`
from `your_table_name`
group by `AddrId`;
-
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 111357 visits
- search for elements in a list 111041 visits
- In Chrome 55, prevent showing Download button for HTML 5 video 98801 visits
- RxJS5 - error - TypeError: You provided an invalid object where a stream was expected 96299 visits
- Ionic 2 - how to make ion-button with icon and text on two lines? 92491 visits
- NetBeans IDE - ClassNotFoundException: net.ucanaccess.jdbc.UcanaccessDriver 62013 visits
- Adding methods to es6 child class 22362 visits
READ ALSO
