j10's user avatar
j10's user avatar
j10's user avatar
j10
  • Member for 6 years, 9 months
  • Last seen more than a month ago
  • India
6 votes
1 answer
16k views

Generate Dates between Date Ranges in mysql

3 votes
1 answer
93 views

Getting the query right?

2 votes
2 answers
560 views

Database Design when Admin and Employee have similar roles except Admin can see all the other Employees Data

2 votes
3 answers
227 views

Define JSON Index for Schemaless using MySQL 8.0

2 votes
2 answers
2k views

count for missing values in group by

1 vote
0 answers
63 views

Select Rows within a Group based on a condition

1 vote
3 answers
2k views

How to generate unique and sequential Id values

1 vote
3 answers
79 views

Index Design going incorrect

1 vote
1 answer
5k views

Cursor Based Pagination for Timestamp field with non-unique values

1 vote
1 answer
356 views

Case statements for multiple fields when only certain cases exist for each field

0 votes
1 answer
40 views

Delete all data for a Single Vendor in the Dabatase

0 votes
1 answer
1k views

How to ensure no duplicate records are added when using multiple Node JS processes

0 votes
1 answer
1k views

Should I use composite key or primary key from other table

0 votes
2 answers
137 views

How to merge records for query set

0 votes
2 answers
186 views

how to formulate query (conditional)

0 votes
1 answer
889 views

How to add slots for Slot table such that there are no clash

0 votes
0 answers
272 views

Generate Slot Summaries(chunks of continuous slots) from the Slot table

0 votes
1 answer
4k views

Inner join on output of a subquery

0 votes
2 answers
53 views

Dynamic query in Stored Procedure over table values

0 votes
1 answer
431 views

How to store tax for a Product when tax rate for a Product can change and tax-exempted Products

0 votes
1 answer
43 views

How to generate missing values for each employee for each day

-1 votes
2 answers
2k views

How to store tax in the database when tax consists of multiple taxes