| CARVIEW |
Select Language
HTTP/2 200
date: Mon, 21 Jul 2025 15:56:13 GMT
content-type: text/html; charset=utf-8
cf-ray: 962be313983a20c5-BLR
cf-cache-status: DYNAMIC
cache-control: private
set-cookie: prov=be09cd33-6cc1-4758-950c-b42b070ff6ac; expires=Tue, 21 Jul 2026 15:56:12 GMT; domain=.stackexchange.com; path=/; secure; httponly
strict-transport-security: max-age=31536000; includeSubDomains
vary: Accept-Encoding
content-security-policy: upgrade-insecure-requests; frame-ancestors 'self' https://stackexchange.com
x-frame-options: SAMEORIGIN
x-request-guid: 4a99f914-635f-4af4-81ff-94ab4afb3b69
x-worker-origin-response-time: 542000000
x-dns-prefetch-control: off
set-cookie: prov=be09cd33-6cc1-4758-950c-b42b070ff6ac; Path=/; HttpOnly; Domain=stackexchange.com
set-cookie: __cf_bm=0EezzhpFI_Xd.FK.g9uqSa2tyrckVjFyYc6GW69k22Q-1753113373-1.0.1.1-D7Ycb5s5IESsqZhtR1UdKvIEITtM_V3h40PnNYpTxgYAaxyY3Y6FYOYIAitcnN0NaElvexC2WpBjPOWY0rK8.x4ppT8uWTThOosyF_8Cn4k; path=/; expires=Mon, 21-Jul-25 16:26:13 GMT; domain=.stackexchange.com; HttpOnly; Secure; SameSite=None
set-cookie: _cfuvid=prUOINYHoQjcnvADmPWpqRLKY8FWGINxWqxv5Cr.vRI-1753113373299-0.0.1.1-604800000; path=/; domain=.stackexchange.com; HttpOnly; Secure; SameSite=None
server: cloudflare
content-encoding: gzip
Newest 'sql' Questions - Code Review Stack Exchange
Skip to main content
Stack Exchange Network
Stack Exchange network consists of 183 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.
Visit Stack Exchange
Teams
Q&A for work
Connect and share knowledge within a single location that is structured and easy to search.
Learn more about TeamsQuestions tagged [sql]
Structured Query Language is a language for interacting with relational databases. Read the tag wiki's guidelines for requesting SQL reviews: 1) Provide context, 2) Include the schema, 3) If asking about performance, include indexes and the output of EXPLAIN SELECT.
1,442 questions
- Bountied 0
- Unanswered
- Frequent
- Score
- Trending
- Week
- Month
- Unanswered (my tags)
6
votes
2
answers
690
views
Weather Observation Station 8 query
Here's my (correct) solution to a HackerRank question:
Weather Observation Station 8
Query the list of CITY names from STATION which have vowels (i.e., a, e, i, o, and u) as both their first and last ...
5
votes
3
answers
1k
views
Slow SQL query with nested subquery
I have written the below query in order to identify how many events (occur over a week) in each hour.
...
4
votes
2
answers
78
views
better-SQLite3 and JS/Next.js - updating data using "transaction"- shorter / better code?
I am pretty new to SQL databases and in particular to the better-SQLite3 database. I have managed to insert, update, and delete data in a way I desire. All of it running in the background of a self-...
9
votes
2
answers
947
views
JavaFX app with User Authentication and SQL Persistence
This JavaFX program is just supposed to allow a user to register a username and password and then have it stored in an SQL database.
There's been some criticism that it's not clean, readable or ...
3
votes
1
answer
183
views
Getting all column vs. table regardless of alias using JSqlParser
I have been trying to get all column vs. table regardless of alias used, for example, assume this query
...
4
votes
1
answer
63
views
Better Microsoft SQL update
I've got the following SQL that I need to update by adding a new parameter:
...
0
votes
2
answers
52
views
Enhancing my query for select information implement in oracle(plus/sql) [closed]
I'm working on my query for select information relate to the order table in oracle. I've written the following code. But I'm looking for suggest on how to improve it.
...
- 79
5
votes
2
answers
695
views
A schema for awallet system that allows transfers between users
I am currently working on a wallet system that allows transfers of money between users. I tried creating this as a Stack Overflow question, but it was rejected. I'm not sure if this is the right ...
3
votes
2
answers
166
views
Clean up verbose code for Oracle SQL
I have the following Oracle SQL code that works, but I would like to try and find a way to clean it up so it's not so repetitive. It is looking at orders for a part ordered each FY in an Oracle ...
3
votes
1
answer
136
views
Faster Query to Track State changes in a Large Table
I have a table that tracks state changes of an entity with timestamps. The schema of the table is as follows:
entityid
userid
originalvalue
newvalue
changetime
255
101
Draft
Submitted
2023-11-28 12:10:...
2
votes
1
answer
71
views
Delete duplicates from SQL database with Python and reset ID's
I tried to create a peice of code that helps me remove duplicates from my sql database and reset the ID's as well.
I am not sure that it's error proof.
...
3
votes
1
answer
72
views
Postgresql generated column from Finnish personal identity code
The Finnish personal identity code is defined as:
Day, month, and year of birth, in ddmmyy form (six digits, zero padded if necessary)
A separator
For those born &...
- 823
2
votes
0
answers
56
views
Case Study: Database design help for a small app used to coach tennis players
I have a small SQL server database and VBA program that is used to automate tasks related to tennis students, programs, practices, performances, and student testing.
I'm trying to learn db design and ...
2
votes
1
answer
85
views
Feedback for my first project - sqlserver-json-tools
could you review my first project on github please. The JSON_MODIFY function in SQL Server 2016 and 2019 does not allow creating paths dynamically, making it necessary to chain JSON_MODIFY executions. ...
2
votes
1
answer
103
views
Determining the least dangerous tags with over 1K answers to answer
So I thought I'd take another shot at making a SEDE query after being somewhat inactive after a while.
Essentially what this does is that it takes the tags that have at least 1000 answers for that tag ...
- The Overflow Blog
-
- Featured on Meta
-
-
Related Tags
sql-server × 460
mysql × 311
performance × 218
t-sql × 206
php × 194
c# × 151
postgresql × 92
database × 90
stackexchange × 75
beginner × 70
python × 64
stored-procedure × 61
oracle × 49
java × 48
join × 43
datetime × 42
optimization × 41
sqlite × 37
pdo × 34
asp.net × 31
mysqli × 31
object-oriented × 29
python-3.x × 29
security × 28
vba × 26
more related tags
Hot Network Questions
- Gauge Transformation in Classical Mechanics
- My shared_ptr implementation
- Ceci n'est pas une affix-riddle...
- Is classical logic the consensus among contemporary logicians?
- From NPN to PNP: What’s Different in Base Control?
- "Warp " Text around curve
- Equivalent idiom in English about something annoyingly appearing everywhere
- How do I apply a gradient color along the length of a mesh generated by a curve in Geometry Nodes?
- How does Rav Kotler assign final letters in 5 cases in Vayikra-Bamidbar?
- What does this "lightbulb-ish" symbol mean in figure 1 of the Diffie Hellmann paper?
- book about a girl traveling through other dimensions
- Why is my gooseberry jam so stiff?
- Are copper and magnesium substituting each other in the mixed oxide lattices?
- Uniqueness of the wedge product in Munkres' “Analysis on Manifolds”
- Can a 2024 Monk use Stunning Strike with a thrown dagger, javelin or spear?
- Wrapping minipage around a tabularx cell produces overlapping text as of TeXLive 2025
- What was intestacy law in 1852 London?
- Interpreting Negative Binomial GLM results and model-fit
- TikZ - Apply different opacity inside and outside a path
- Replacing an old racing bike transmission : same component or newer ones?
- What tools do I need to remove this Shimano bottom bracket marked 'BC 1:37x24 Road'?
- What are the differences between a big jet engine and a small jet engine?
- Is it legal for businesses to give financial incentives for leaving positive reviews on review sites (e.g., Google Maps, Yelp, Facebook, Amazon)?
- How is “unerlaubt” working in this paragraph?