Mixing
Sqlite - How to i query like call log if there is same number continue get as single record with continuously...
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}
2
UniqueID | MobileNumber | createDate
-----------+---------+-----+------------+-----------
U_23121 | 987654 | 2013-02-05
U_23124 | 987654 | 2013-02-02
U_23122 | 845263 | 2013-01-18
U_23128 | 654789 | 2013-01-16
U_23123 | 735689 | 2013-01-12
U_23128 | 654789 | 2013-01-11
U_23128 | 654789 | 2013-01-10
U_23126 | 987654 | 2013-01-09
U_23125 | 845263 | 2013-01-07
U_23126 | 845263 | 2013-01-06
U_23125 | 987654 | 2013-01-05
I want to record like filtering with mobile number if more then one continue get latest based on createdDate and get count for that like
UniqueID | Mobile_Number | createDate | count
-----------+---------+-----+------------+-----------
U_23121 | 987654 | 2013-02-05 | 2
U_23122 | 845263 | 2013-01-18 | 1
U_23128 | 654789 | 2013-01-16 | 1
U_23123 | 735689 | 2013-01-12 | 1
U_23128 | 654789 | 2013-01-11 | 2
U_23126 | 987654 | 2013-01-09 | 1
U_23125 | 845263 | 2013-01-07 | 2
U_23125 | 987654 | 2013-01-05 | 1
I'll get record that is need from following query but not getting count
SELECT te.*
FROM tableName as te
WHERE te.Mobile_Number <> (select Mobile_Number
from tableName
where createDate > te.createDate
limit 1
)
ORDER BY te.createDate DESC
android sql database gaps-and-islands edited Jan 3 at 12:10
Gordon Linoff
794k37318422
asked Jan 3 at 6:10
Chirag.TChirag.T
560417
|
show 3 more comments
2
UniqueID | MobileNumber | createDate
-----------+---------+-----+------------+-----------
U_23121 | 987654 | 2013-02-05
U_23124 | 987654 | 2013-02-02
U_23122 | 845263 | 2013-01-18
U_23128 | 654789 | 2013-01-16
U_23123 | 735689 | 2013-01-12
U_23128 | 654789 | 2013-01-11
U_23128 | 654789 | 2013-01-10
U_23126 | 987654 | 2013-01-09
U_23125 | 845263 | 2013-01-07
U_23126 | 845263 | 2013-01-06
U_23125 | 987654 | 2013-01-05
I want to record like filtering with mobile number if more then one continue get latest based on createdDate and get count for that like
UniqueID | Mobile_Number | createDate | count
-----------+---------+-----+------------+-----------
U_23121 | 987654 | 2013-02-05 | 2
U_23122 | 845263 | 2013-01-18 | 1
U_23128 | 654789 | 2013-01-16 | 1
U_23123 | 735689 | 2013-01-12 | 1
U_23128 | 654789 | 2013-01-11 | 2
U_23126 | 987654 | 2013-01-09 | 1
U_23125 | 845263 | 2013-01-07 | 2
U_23125 | 987654 | 2013-01-05 | 1
I'll get record that is need from following query but not getting count
SELECT te.*
FROM tableName as te
WHERE te.Mobile_Number <> (select Mobile_Number
from tableName
where createDate > te.createDate
limit 1
)
ORDER BY te.createDate DESC
edited Jan 3 at 12:10
Gordon Linoff
794k37318422
asked Jan 3 at 6:10
Chirag.TChirag.T
560417
its mysql or sqlite? these are different DBMS. If it is a mysql then write the version you are using. I have changed the tags.
– Radim Bača
Jan 3 at 8:29
@RadimBača is SQLITE
– Chirag.T
Jan 3 at 8:57
and which version of sqlite? do you have 3.25 or more?
– Radim Bača
Jan 3 at 9:23
is query needs for android SQLITE db so maybe it's not effect versions.
– Chirag.T
Jan 3 at 11:15
can you testselect row_number() over (order by createdate) from tablenamequery in your db?
– Radim Bača
Jan 3 at 11:19
|
show 3 more comments
2
2
2
UniqueID | MobileNumber | createDate
-----------+---------+-----+------------+-----------
U_23121 | 987654 | 2013-02-05
U_23124 | 987654 | 2013-02-02
U_23122 | 845263 | 2013-01-18
U_23128 | 654789 | 2013-01-16
U_23123 | 735689 | 2013-01-12
U_23128 | 654789 | 2013-01-11
U_23128 | 654789 | 2013-01-10
U_23126 | 987654 | 2013-01-09
U_23125 | 845263 | 2013-01-07
U_23126 | 845263 | 2013-01-06
U_23125 | 987654 | 2013-01-05
I want to record like filtering with mobile number if more then one continue get latest based on createdDate and get count for that like
UniqueID | Mobile_Number | createDate | count
-----------+---------+-----+------------+-----------
U_23121 | 987654 | 2013-02-05 | 2
U_23122 | 845263 | 2013-01-18 | 1
U_23128 | 654789 | 2013-01-16 | 1
U_23123 | 735689 | 2013-01-12 | 1
U_23128 | 654789 | 2013-01-11 | 2
U_23126 | 987654 | 2013-01-09 | 1
U_23125 | 845263 | 2013-01-07 | 2
U_23125 | 987654 | 2013-01-05 | 1
I'll get record that is need from following query but not getting count
SELECT te.*
FROM tableName as te
WHERE te.Mobile_Number <> (select Mobile_Number
from tableName
where createDate > te.createDate
limit 1
)
ORDER BY te.createDate DESC
edited Jan 3 at 12:10
Gordon Linoff
794k37318422
asked Jan 3 at 6:10
Chirag.TChirag.T
560417
UniqueID | MobileNumber | createDate
-----------+---------+-----+------------+-----------
U_23121 | 987654 | 2013-02-05
U_23124 | 987654 | 2013-02-02
U_23122 | 845263 | 2013-01-18
U_23128 | 654789 | 2013-01-16
U_23123 | 735689 | 2013-01-12
U_23128 | 654789 | 2013-01-11
U_23128 | 654789 | 2013-01-10
U_23126 | 987654 | 2013-01-09
U_23125 | 845263 | 2013-01-07
U_23126 | 845263 | 2013-01-06
U_23125 | 987654 | 2013-01-05
I want to record like filtering with mobile number if more then one continue get latest based on createdDate and get count for that like
UniqueID | Mobile_Number | createDate | count
-----------+---------+-----+------------+-----------
U_23121 | 987654 | 2013-02-05 | 2
U_23122 | 845263 | 2013-01-18 | 1
U_23128 | 654789 | 2013-01-16 | 1
U_23123 | 735689 | 2013-01-12 | 1
U_23128 | 654789 | 2013-01-11 | 2
U_23126 | 987654 | 2013-01-09 | 1
U_23125 | 845263 | 2013-01-07 | 2
U_23125 | 987654 | 2013-01-05 | 1
I'll get record that is need from following query but not getting count
SELECT te.*
FROM tableName as te
WHERE te.Mobile_Number <> (select Mobile_Number
from tableName
where createDate > te.createDate
limit 1
)
ORDER BY te.createDate DESC
edited Jan 3 at 12:10
Gordon Linoff
794k37318422
asked Jan 3 at 6:10
Chirag.TChirag.T
560417
edited Jan 3 at 12:10
Gordon Linoff
794k37318422
asked Jan 3 at 6:10
Chirag.TChirag.T
560417
edited Jan 3 at 12:10
Gordon Linoff
794k37318422
edited Jan 3 at 12:10
Gordon Linoff
794k37318422
edited Jan 3 at 12:10
Gordon Linoff
794k37318422
794k37318422
asked Jan 3 at 6:10
Chirag.TChirag.T
560417
asked Jan 3 at 6:10
Chirag.TChirag.T
560417
asked Jan 3 at 6:10
Chirag.TChirag.T
560417
560417
its mysql or sqlite? these are different DBMS. If it is a mysql then write the version you are using. I have changed the tags.
– Radim Bača
Jan 3 at 8:29
@RadimBača is SQLITE
– Chirag.T
Jan 3 at 8:57
and which version of sqlite? do you have 3.25 or more?
– Radim Bača
Jan 3 at 9:23
is query needs for android SQLITE db so maybe it's not effect versions.
– Chirag.T
Jan 3 at 11:15
can you testselect row_number() over (order by createdate) from tablenamequery in your db?
– Radim Bača
Jan 3 at 11:19
|
show 3 more comments
its mysql or sqlite? these are different DBMS. If it is a mysql then write the version you are using. I have changed the tags.
– Radim Bača
Jan 3 at 8:29
@RadimBača is SQLITE
– Chirag.T
Jan 3 at 8:57
and which version of sqlite? do you have 3.25 or more?
– Radim Bača
Jan 3 at 9:23
is query needs for android SQLITE db so maybe it's not effect versions.
– Chirag.T
Jan 3 at 11:15
can you testselect row_number() over (order by createdate) from tablenamequery in your db?
– Radim Bača
Jan 3 at 11:19
its mysql or sqlite? these are different DBMS. If it is a mysql then write the version you are using. I have changed the tags.
– Radim Bača
Jan 3 at 8:29
its mysql or sqlite? these are different DBMS. If it is a mysql then write the version you are using. I have changed the tags.
– Radim Bača
Jan 3 at 8:29
@RadimBača is SQLITE
– Chirag.T
Jan 3 at 8:57
@RadimBača is SQLITE
– Chirag.T
Jan 3 at 8:57
and which version of sqlite? do you have 3.25 or more?
– Radim Bača
Jan 3 at 9:23
and which version of sqlite? do you have 3.25 or more?
– Radim Bača
Jan 3 at 9:23
is query needs for android SQLITE db so maybe it's not effect versions.
– Chirag.T
Jan 3 at 11:15
is query needs for android SQLITE db so maybe it's not effect versions.
– Chirag.T
Jan 3 at 11:15
can you test
select row_number() over (order by createdate) from tablename query in your db?– Radim Bača
Jan 3 at 11:19
can you test
select row_number() over (order by createdate) from tablename query in your db?– Radim Bača
Jan 3 at 11:19
|
show 3 more comments
3 Answers
3
active
oldest
votes
1
This is a gaps-and-islands problem. One solution is to assign a "grp" to each row and then aggregate by that group.
You can assign the grp by counting the number of mobile numbers that are different from the mobile number in each row, up to that row. This is a constant value for adjacent mobile numbers.
The resulting query:
SELECT MAX(UniqueId), MobileNumber,
MAX(createDate), COUNT(*)
FROM (SELECT te.*,
(SELECT COUNT(*)
FROM tableName te2
WHERE te2.createDate < te.createDate AND
te2.MobileNumber <> te.MobileNumber
) as grp
FROM tableName te
) te
GROUP BY MobileNumber, grp;
ORDER BY MIN(tcreateDate) DESC
answered Jan 3 at 12:14
Gordon LinoffGordon Linoff
794k37318422
Thanks it's working
– Chirag.T
Jan 3 at 13:57
add a comment |
0
Ok, this is the gaps and islands problem. If your Sqllite supports the row_number function (version 3.25 and more) then you can use the following approach
select MobileNumber, max(createDate), count(*)
from
(
select *,
row_number() over (order by createDate) -
row_number() over (partition by MobileNumber order by createDate) grp
from data
) t
group by grp, MobileNumber
answered Jan 3 at 11:55
Radim BačaRadim Bača
8,91611226
there is error with your query near "(" can u run query ?
– Chirag.T
Jan 3 at 12:10
I've tested only on the PostgreSQL, however, it should work if your sqlite supportrow_number. Can you try to run only the subquerytand let me know?
– Radim Bača
Jan 3 at 13:46
add a comment |
-1
USE GROUP BY
SELECT te.* FROM tableName as te where te.Mobile_Number != (select Mobile_Number from tableName where createDate > te.createDate limit 1) GROUP BY Mobile_Number ORDER BY te.createDate DESC
answered Jan 3 at 6:13
RamRam
397
group by combine all same Mobile_Number record i'll want to combine if there is next is same as per date, please see question and example that i provide. Thanks @Ram
– Chirag.T
Jan 3 at 6:16
add a comment |
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%2f54017142%2fsqlite-how-to-i-query-like-call-log-if-there-is-same-number-continue-get-as-si%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
3 Answers
3
active
oldest
votes
3 Answers
3
active
oldest
votes
active
oldest
votes
active
oldest
votes
1
This is a gaps-and-islands problem. One solution is to assign a "grp" to each row and then aggregate by that group.
You can assign the grp by counting the number of mobile numbers that are different from the mobile number in each row, up to that row. This is a constant value for adjacent mobile numbers.
The resulting query:
SELECT MAX(UniqueId), MobileNumber,
MAX(createDate), COUNT(*)
FROM (SELECT te.*,
(SELECT COUNT(*)
FROM tableName te2
WHERE te2.createDate < te.createDate AND
te2.MobileNumber <> te.MobileNumber
) as grp
FROM tableName te
) te
GROUP BY MobileNumber, grp;
ORDER BY MIN(tcreateDate) DESC
answered Jan 3 at 12:14
Gordon LinoffGordon Linoff
794k37318422
Thanks it's working
– Chirag.T
Jan 3 at 13:57
add a comment |
1
This is a gaps-and-islands problem. One solution is to assign a "grp" to each row and then aggregate by that group.
You can assign the grp by counting the number of mobile numbers that are different from the mobile number in each row, up to that row. This is a constant value for adjacent mobile numbers.
The resulting query:
SELECT MAX(UniqueId), MobileNumber,
MAX(createDate), COUNT(*)
FROM (SELECT te.*,
(SELECT COUNT(*)
FROM tableName te2
WHERE te2.createDate < te.createDate AND
te2.MobileNumber <> te.MobileNumber
) as grp
FROM tableName te
) te
GROUP BY MobileNumber, grp;
ORDER BY MIN(tcreateDate) DESC
answered Jan 3 at 12:14
Gordon LinoffGordon Linoff
794k37318422
Thanks it's working
– Chirag.T
Jan 3 at 13:57
add a comment |
1
1
1
This is a gaps-and-islands problem. One solution is to assign a "grp" to each row and then aggregate by that group.
You can assign the grp by counting the number of mobile numbers that are different from the mobile number in each row, up to that row. This is a constant value for adjacent mobile numbers.
The resulting query:
SELECT MAX(UniqueId), MobileNumber,
MAX(createDate), COUNT(*)
FROM (SELECT te.*,
(SELECT COUNT(*)
FROM tableName te2
WHERE te2.createDate < te.createDate AND
te2.MobileNumber <> te.MobileNumber
) as grp
FROM tableName te
) te
GROUP BY MobileNumber, grp;
ORDER BY MIN(tcreateDate) DESC
answered Jan 3 at 12:14
Gordon LinoffGordon Linoff
794k37318422
This is a gaps-and-islands problem. One solution is to assign a "grp" to each row and then aggregate by that group.
You can assign the grp by counting the number of mobile numbers that are different from the mobile number in each row, up to that row. This is a constant value for adjacent mobile numbers.
The resulting query:
SELECT MAX(UniqueId), MobileNumber,
MAX(createDate), COUNT(*)
FROM (SELECT te.*,
(SELECT COUNT(*)
FROM tableName te2
WHERE te2.createDate < te.createDate AND
te2.MobileNumber <> te.MobileNumber
) as grp
FROM tableName te
) te
GROUP BY MobileNumber, grp;
ORDER BY MIN(tcreateDate) DESC
answered Jan 3 at 12:14
Gordon LinoffGordon Linoff
794k37318422
edited Jan 3 at 14:16
answered Jan 3 at 12:14
Gordon LinoffGordon Linoff
794k37318422
answered Jan 3 at 12:14
Gordon LinoffGordon Linoff
794k37318422
answered Jan 3 at 12:14
Gordon LinoffGordon Linoff
794k37318422
794k37318422
Thanks it's working
– Chirag.T
Jan 3 at 13:57
add a comment |
Thanks it's working
– Chirag.T
Jan 3 at 13:57
Thanks it's working
– Chirag.T
Jan 3 at 13:57
Thanks it's working
– Chirag.T
Jan 3 at 13:57
add a comment |
0
Ok, this is the gaps and islands problem. If your Sqllite supports the row_number function (version 3.25 and more) then you can use the following approach
select MobileNumber, max(createDate), count(*)
from
(
select *,
row_number() over (order by createDate) -
row_number() over (partition by MobileNumber order by createDate) grp
from data
) t
group by grp, MobileNumber
answered Jan 3 at 11:55
Radim BačaRadim Bača
8,91611226
there is error with your query near "(" can u run query ?
– Chirag.T
Jan 3 at 12:10
I've tested only on the PostgreSQL, however, it should work if your sqlite supportrow_number. Can you try to run only the subquerytand let me know?
– Radim Bača
Jan 3 at 13:46
add a comment |
0
Ok, this is the gaps and islands problem. If your Sqllite supports the row_number function (version 3.25 and more) then you can use the following approach
select MobileNumber, max(createDate), count(*)
from
(
select *,
row_number() over (order by createDate) -
row_number() over (partition by MobileNumber order by createDate) grp
from data
) t
group by grp, MobileNumber
answered Jan 3 at 11:55
Radim BačaRadim Bača
8,91611226
there is error with your query near "(" can u run query ?
– Chirag.T
Jan 3 at 12:10
I've tested only on the PostgreSQL, however, it should work if your sqlite supportrow_number. Can you try to run only the subquerytand let me know?
– Radim Bača
Jan 3 at 13:46
add a comment |
0
0
0
Ok, this is the gaps and islands problem. If your Sqllite supports the row_number function (version 3.25 and more) then you can use the following approach
select MobileNumber, max(createDate), count(*)
from
(
select *,
row_number() over (order by createDate) -
row_number() over (partition by MobileNumber order by createDate) grp
from data
) t
group by grp, MobileNumber
answered Jan 3 at 11:55
Radim BačaRadim Bača
8,91611226
Ok, this is the gaps and islands problem. If your Sqllite supports the row_number function (version 3.25 and more) then you can use the following approach
select MobileNumber, max(createDate), count(*)
from
(
select *,
row_number() over (order by createDate) -
row_number() over (partition by MobileNumber order by createDate) grp
from data
) t
group by grp, MobileNumber
answered Jan 3 at 11:55
Radim BačaRadim Bača
8,91611226
answered Jan 3 at 11:55
Radim BačaRadim Bača
8,91611226
answered Jan 3 at 11:55
Radim BačaRadim Bača
8,91611226
answered Jan 3 at 11:55
Radim BačaRadim Bača
8,91611226
8,91611226
there is error with your query near "(" can u run query ?
– Chirag.T
Jan 3 at 12:10
I've tested only on the PostgreSQL, however, it should work if your sqlite supportrow_number. Can you try to run only the subquerytand let me know?
– Radim Bača
Jan 3 at 13:46
add a comment |
there is error with your query near "(" can u run query ?
– Chirag.T
Jan 3 at 12:10
I've tested only on the PostgreSQL, however, it should work if your sqlite supportrow_number. Can you try to run only the subquerytand let me know?
– Radim Bača
Jan 3 at 13:46
there is error with your query near "(" can u run query ?
– Chirag.T
Jan 3 at 12:10
there is error with your query near "(" can u run query ?
– Chirag.T
Jan 3 at 12:10
I've tested only on the PostgreSQL, however, it should work if your sqlite support
row_number. Can you try to run only the subquery t and let me know?– Radim Bača
Jan 3 at 13:46
I've tested only on the PostgreSQL, however, it should work if your sqlite support
row_number. Can you try to run only the subquery t and let me know?– Radim Bača
Jan 3 at 13:46
add a comment |
-1
USE GROUP BY
SELECT te.* FROM tableName as te where te.Mobile_Number != (select Mobile_Number from tableName where createDate > te.createDate limit 1) GROUP BY Mobile_Number ORDER BY te.createDate DESC
answered Jan 3 at 6:13
RamRam
397
group by combine all same Mobile_Number record i'll want to combine if there is next is same as per date, please see question and example that i provide. Thanks @Ram
– Chirag.T
Jan 3 at 6:16
add a comment |
-1
USE GROUP BY
SELECT te.* FROM tableName as te where te.Mobile_Number != (select Mobile_Number from tableName where createDate > te.createDate limit 1) GROUP BY Mobile_Number ORDER BY te.createDate DESC
answered Jan 3 at 6:13
RamRam
397
group by combine all same Mobile_Number record i'll want to combine if there is next is same as per date, please see question and example that i provide. Thanks @Ram
– Chirag.T
Jan 3 at 6:16
add a comment |
-1
-1
-1
USE GROUP BY
SELECT te.* FROM tableName as te where te.Mobile_Number != (select Mobile_Number from tableName where createDate > te.createDate limit 1) GROUP BY Mobile_Number ORDER BY te.createDate DESC
answered Jan 3 at 6:13
RamRam
397
USE GROUP BY
SELECT te.* FROM tableName as te where te.Mobile_Number != (select Mobile_Number from tableName where createDate > te.createDate limit 1) GROUP BY Mobile_Number ORDER BY te.createDate DESC
answered Jan 3 at 6:13
RamRam
397
answered Jan 3 at 6:13
RamRam
397
answered Jan 3 at 6:13
RamRam
397
answered Jan 3 at 6:13
RamRam
397
397
group by combine all same Mobile_Number record i'll want to combine if there is next is same as per date, please see question and example that i provide. Thanks @Ram
– Chirag.T
Jan 3 at 6:16
add a comment |
group by combine all same Mobile_Number record i'll want to combine if there is next is same as per date, please see question and example that i provide. Thanks @Ram
– Chirag.T
Jan 3 at 6:16
group by combine all same Mobile_Number record i'll want to combine if there is next is same as per date, please see question and example that i provide. Thanks @Ram
– Chirag.T
Jan 3 at 6:16
group by combine all same Mobile_Number record i'll want to combine if there is next is same as per date, please see question and example that i provide. Thanks @Ram
– Chirag.T
Jan 3 at 6:16
add a comment |
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%2f54017142%2fsqlite-how-to-i-query-like-call-log-if-there-is-same-number-continue-get-as-si%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
its mysql or sqlite? these are different DBMS. If it is a mysql then write the version you are using. I have changed the tags.
– Radim Bača
Jan 3 at 8:29
@RadimBača is SQLITE
– Chirag.T
Jan 3 at 8:57
and which version of sqlite? do you have 3.25 or more?
– Radim Bača
Jan 3 at 9:23
is query needs for android SQLITE db so maybe it's not effect versions.
– Chirag.T
Jan 3 at 11:15
can you test
select row_number() over (order by createdate) from tablenamequery in your db?– Radim Bača
Jan 3 at 11:19