Distinct() is not giving distinct row in laravel
0
DB::table('paperregisters')
->join('syllabuses','paperregisters.deptoffering_id','=','syllabuses.deptoffering_id')
->where('paperregisters.email','=',$user->email)
->distinct('paperregisters.admno')
->get();
I am trying to retrieve unique admno values. The above code result retrieve duplicate values. The paperregisters table has id of 1,2 and syllabuses table has id 1 , 2. i am getting result from both table
current result
Expected result
laravel laravel-5.6
asked Nov 16 '18 at 6:06
Vinod SVinod S
14
add a comment |
0
DB::table('paperregisters')
->join('syllabuses','paperregisters.deptoffering_id','=','syllabuses.deptoffering_id')
->where('paperregisters.email','=',$user->email)
->distinct('paperregisters.admno')
->get();
I am trying to retrieve unique admno values. The above code result retrieve duplicate values. The paperregisters table has id of 1,2 and syllabuses table has id 1 , 2. i am getting result from both table
current result
Expected result
laravel laravel-5.6
asked Nov 16 '18 at 6:06
Vinod SVinod S
14
add a comment |
0
0
0
DB::table('paperregisters')
->join('syllabuses','paperregisters.deptoffering_id','=','syllabuses.deptoffering_id')
->where('paperregisters.email','=',$user->email)
->distinct('paperregisters.admno')
->get();
I am trying to retrieve unique admno values. The above code result retrieve duplicate values. The paperregisters table has id of 1,2 and syllabuses table has id 1 , 2. i am getting result from both table
current result
Expected result
laravel laravel-5.6
asked Nov 16 '18 at 6:06
Vinod SVinod S
14
DB::table('paperregisters')
->join('syllabuses','paperregisters.deptoffering_id','=','syllabuses.deptoffering_id')
->where('paperregisters.email','=',$user->email)
->distinct('paperregisters.admno')
->get();
I am trying to retrieve unique admno values. The above code result retrieve duplicate values. The paperregisters table has id of 1,2 and syllabuses table has id 1 , 2. i am getting result from both table
current result
Expected result
laravel laravel-5.6
laravel laravel-5.6
asked Nov 16 '18 at 6:06
Vinod SVinod S
14
asked Nov 16 '18 at 6:06
Vinod SVinod S
14
edited Nov 16 '18 at 7:10
Vinod S
asked Nov 16 '18 at 6:06
Vinod SVinod S
14
asked Nov 16 '18 at 6:06
Vinod SVinod S
14
asked Nov 16 '18 at 6:06
Vinod SVinod S
14
14
add a comment |
add a comment |
2 Answers
2
active
oldest
votes
0
Try adding a select to select the fields that you want in the final records
eg.
->select(['paperregisters.admno', 'syllabuses.deptoffering_id' ....])->get()
answered Nov 16 '18 at 6:47
JoshJosh
718318
add a comment |
0
Use GROUP BY instead of distinct
Query
DB::table('paperregisters')
->join('syllabuses','paperregisters.deptoffering_id','=','syllabuses.deptoffering_id')
->where('paperregisters.email','=',$user->email)
->groupBy('paperregisters.admno')
->get();
edited Nov 16 '18 at 7:42
Ali
375315
answered Nov 16 '18 at 6:09
Bhargav ChudasamaBhargav Chudasama
4,3802927
I tried this if I used groupBy i will get only one row result. i need id 1 and 2. The above code result show 1,2 from paperregisters and 1,2 from syllabuses.
– Vinod S
Nov 16 '18 at 6:20
what field name of1,2record in table
– Bhargav Chudasama
Nov 16 '18 at 6:23
1 and 2 are admno of both table. I have tried this Mysql I have retrieved result but I'm not getting here in laravel
– Vinod S
Nov 16 '18 at 6:26
so you putyour current resultandexpected resultwith field name
– Bhargav Chudasama
Nov 16 '18 at 6:30
My expected output should be i have get distinct result from paperregisters. My current result is:I'm getting result from both table
– Vinod S
Nov 16 '18 at 6:39
|
show 2 more comments
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53332319%2fdistinct-is-not-giving-distinct-row-in-laravel%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
0
Try adding a select to select the fields that you want in the final records
eg.
->select(['paperregisters.admno', 'syllabuses.deptoffering_id' ....])->get()
answered Nov 16 '18 at 6:47
JoshJosh
718318
add a comment |
0
Try adding a select to select the fields that you want in the final records
eg.
->select(['paperregisters.admno', 'syllabuses.deptoffering_id' ....])->get()
answered Nov 16 '18 at 6:47
JoshJosh
718318
add a comment |
0
0
0
Try adding a select to select the fields that you want in the final records
eg.
->select(['paperregisters.admno', 'syllabuses.deptoffering_id' ....])->get()
answered Nov 16 '18 at 6:47
JoshJosh
718318
Try adding a select to select the fields that you want in the final records
eg.
->select(['paperregisters.admno', 'syllabuses.deptoffering_id' ....])->get()
answered Nov 16 '18 at 6:47
JoshJosh
718318
answered Nov 16 '18 at 6:47
JoshJosh
718318
answered Nov 16 '18 at 6:47
JoshJosh
718318
answered Nov 16 '18 at 6:47
JoshJosh
718318
718318
add a comment |
add a comment |
0
Use GROUP BY instead of distinct
Query
DB::table('paperregisters')
->join('syllabuses','paperregisters.deptoffering_id','=','syllabuses.deptoffering_id')
->where('paperregisters.email','=',$user->email)
->groupBy('paperregisters.admno')
->get();
edited Nov 16 '18 at 7:42
Ali
375315
answered Nov 16 '18 at 6:09
Bhargav ChudasamaBhargav Chudasama
4,3802927
I tried this if I used groupBy i will get only one row result. i need id 1 and 2. The above code result show 1,2 from paperregisters and 1,2 from syllabuses.
– Vinod S
Nov 16 '18 at 6:20
what field name of1,2record in table
– Bhargav Chudasama
Nov 16 '18 at 6:23
1 and 2 are admno of both table. I have tried this Mysql I have retrieved result but I'm not getting here in laravel
– Vinod S
Nov 16 '18 at 6:26
so you putyour current resultandexpected resultwith field name
– Bhargav Chudasama
Nov 16 '18 at 6:30
My expected output should be i have get distinct result from paperregisters. My current result is:I'm getting result from both table
– Vinod S
Nov 16 '18 at 6:39
|
show 2 more comments
0
Use GROUP BY instead of distinct
Query
DB::table('paperregisters')
->join('syllabuses','paperregisters.deptoffering_id','=','syllabuses.deptoffering_id')
->where('paperregisters.email','=',$user->email)
->groupBy('paperregisters.admno')
->get();
edited Nov 16 '18 at 7:42
Ali
375315
answered Nov 16 '18 at 6:09
Bhargav ChudasamaBhargav Chudasama
4,3802927
I tried this if I used groupBy i will get only one row result. i need id 1 and 2. The above code result show 1,2 from paperregisters and 1,2 from syllabuses.
– Vinod S
Nov 16 '18 at 6:20
what field name of1,2record in table
– Bhargav Chudasama
Nov 16 '18 at 6:23
1 and 2 are admno of both table. I have tried this Mysql I have retrieved result but I'm not getting here in laravel
– Vinod S
Nov 16 '18 at 6:26
so you putyour current resultandexpected resultwith field name
– Bhargav Chudasama
Nov 16 '18 at 6:30
My expected output should be i have get distinct result from paperregisters. My current result is:I'm getting result from both table
– Vinod S
Nov 16 '18 at 6:39
|
show 2 more comments
0
0
0
Use GROUP BY instead of distinct
Query
DB::table('paperregisters')
->join('syllabuses','paperregisters.deptoffering_id','=','syllabuses.deptoffering_id')
->where('paperregisters.email','=',$user->email)
->groupBy('paperregisters.admno')
->get();
edited Nov 16 '18 at 7:42
Ali
375315
answered Nov 16 '18 at 6:09
Bhargav ChudasamaBhargav Chudasama
4,3802927
Use GROUP BY instead of distinct
Query
DB::table('paperregisters')
->join('syllabuses','paperregisters.deptoffering_id','=','syllabuses.deptoffering_id')
->where('paperregisters.email','=',$user->email)
->groupBy('paperregisters.admno')
->get();
edited Nov 16 '18 at 7:42
Ali
375315
answered Nov 16 '18 at 6:09
Bhargav ChudasamaBhargav Chudasama
4,3802927
edited Nov 16 '18 at 7:42
Ali
375315
edited Nov 16 '18 at 7:42
Ali
375315
edited Nov 16 '18 at 7:42
Ali
375315
375315
answered Nov 16 '18 at 6:09
Bhargav ChudasamaBhargav Chudasama
4,3802927
answered Nov 16 '18 at 6:09
Bhargav ChudasamaBhargav Chudasama
4,3802927
answered Nov 16 '18 at 6:09
Bhargav ChudasamaBhargav Chudasama
4,3802927
4,3802927
I tried this if I used groupBy i will get only one row result. i need id 1 and 2. The above code result show 1,2 from paperregisters and 1,2 from syllabuses.
– Vinod S
Nov 16 '18 at 6:20
what field name of1,2record in table
– Bhargav Chudasama
Nov 16 '18 at 6:23
1 and 2 are admno of both table. I have tried this Mysql I have retrieved result but I'm not getting here in laravel
– Vinod S
Nov 16 '18 at 6:26
so you putyour current resultandexpected resultwith field name
– Bhargav Chudasama
Nov 16 '18 at 6:30
My expected output should be i have get distinct result from paperregisters. My current result is:I'm getting result from both table
– Vinod S
Nov 16 '18 at 6:39
|
show 2 more comments
I tried this if I used groupBy i will get only one row result. i need id 1 and 2. The above code result show 1,2 from paperregisters and 1,2 from syllabuses.
– Vinod S
Nov 16 '18 at 6:20
what field name of1,2record in table
– Bhargav Chudasama
Nov 16 '18 at 6:23
1 and 2 are admno of both table. I have tried this Mysql I have retrieved result but I'm not getting here in laravel
– Vinod S
Nov 16 '18 at 6:26
so you putyour current resultandexpected resultwith field name
– Bhargav Chudasama
Nov 16 '18 at 6:30
My expected output should be i have get distinct result from paperregisters. My current result is:I'm getting result from both table
– Vinod S
Nov 16 '18 at 6:39
I tried this if I used groupBy i will get only one row result. i need id 1 and 2. The above code result show 1,2 from paperregisters and 1,2 from syllabuses.
– Vinod S
Nov 16 '18 at 6:20
I tried this if I used groupBy i will get only one row result. i need id 1 and 2. The above code result show 1,2 from paperregisters and 1,2 from syllabuses.
– Vinod S
Nov 16 '18 at 6:20
what field name of
1,2 record in table– Bhargav Chudasama
Nov 16 '18 at 6:23
what field name of
1,2 record in table– Bhargav Chudasama
Nov 16 '18 at 6:23
1 and 2 are admno of both table. I have tried this Mysql I have retrieved result but I'm not getting here in laravel
– Vinod S
Nov 16 '18 at 6:26
1 and 2 are admno of both table. I have tried this Mysql I have retrieved result but I'm not getting here in laravel
– Vinod S
Nov 16 '18 at 6:26
so you put
your current result and expected result with field name– Bhargav Chudasama
Nov 16 '18 at 6:30
so you put
your current result and expected result with field name– Bhargav Chudasama
Nov 16 '18 at 6:30
My expected output should be i have get distinct result from paperregisters. My current result is:I'm getting result from both table
– Vinod S
Nov 16 '18 at 6:39
My expected output should be i have get distinct result from paperregisters. My current result is:I'm getting result from both table
– Vinod S
Nov 16 '18 at 6:39
|
show 2 more comments
draft saved
draft discarded
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53332319%2fdistinct-is-not-giving-distinct-row-in-laravel%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
