| CARVIEW |
Select Language
HTTP/2 200
date: Tue, 22 Jul 2025 23:00:33 GMT
content-type: text/html; charset=utf-8
cf-ray: 96368e06fffdc1a1-BLR
cf-cache-status: DYNAMIC
cache-control: private
set-cookie: prov=c930969f-68c7-4c9d-961e-feeb3bcaf35d; expires=Wed, 22 Jul 2026 23:00:32 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-miniprofiler-ids: ["0e39a814-c6ae-40aa-89fd-e760961e80c8"]
x-request-guid: 0e39a814-c6ae-40aa-89fd-e760961e80c8
x-worker-origin-response-time: 517000000
x-dns-prefetch-control: off
set-cookie: prov=c930969f-68c7-4c9d-961e-feeb3bcaf35d; Path=/; HttpOnly; Domain=stackexchange.com
set-cookie: __cf_bm=T7jXLjdiBfmCQB3B4ryqmii_d_wjVOYtQfVYZM0luYg-1753225233-1.0.1.1-LgVdpZG3DQVtuiVGxdJyOVx7udWbUhFsshBeosLS.3rld5D9q_C_0CYTccP1ehFGGJeG88BOFiGl47vMF69gvl3ysXinfMqMMlp54s_y4D8; path=/; expires=Tue, 22-Jul-25 23:30:33 GMT; domain=.stackexchange.com; HttpOnly; Secure; SameSite=None
set-cookie: _cfuvid=vz7bjfG0PnKB1rekxvajSGyI0coVef.tBUgFvhtNKyY-1753225233003-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
- Explorers land on alien planet on which is a dark/black tower which can control machinery
- How to run CorePipeline.Run("contentSearch.PopulateSolrSchema", args); outside of regular sitecore environment
- effectivenes of bear horn vs bear spray
- Will a restless MCU survive long enough?
- grep behaviour is different in subshell
- What was the source of the image of pelican in Catholic churches?
- Calculating the wall thickness in a hollow rotating cylinder space habitat
- How much time should I take for "self transfer" without checked-in baggage?
- What Does It Mean to ‘Continue in My Word’ in John 8:31?
- Can heat be converted to light (possibly via infra-red)? For an underground setting
- How to describe this set more explicitly?
- Can formal parameters inside the function not be dropped even if the function returns until the caller statement ends?
- What fiction genres do literary agents recognize?
- Did Germany declare the Donetsk People’s Republic to be a terrorist organization, at some point?
- Ubuntu gives the message "You are in emergency mode."
- Enlarged Graph vertices are covering up edge arrows
- Why is there a broom in 歸?
- Is there a formal threshold for when a variable is considered 'random' in statistics? What is it?
- A word that describes some people
- Manga/manhwa where protagonist is the only one summoned to a different other world
- Repository with SQLite in Python
- TV episode where a disfigured human exchanges places with a normal-looking human from another planet
- Ceci n'est pas une affix-riddle...
- I wonder whether there exists a book of "Formal power series" and "Formal infinite products"?