Questions about sql-like
Read more about sql-like
python (65.2k questions)
javascript (44.3k questions)
reactjs (22.7k questions)
java (20.8k questions)
c# (17.4k questions)
html (16.3k questions)
r (13.7k questions)
android (13k questions)
Why doesn't select using like query in json string?
I can find whit this query
SELECT *
FROM Table
WHERE CODE_DESC = '{"title:\["1","2","3"\]"}'
But, I can't find this query
SELECT *
FROM Table
WHERE CODE_DE...
Jeremy
Votes: 0
Answers: 1
Select records that do not start with "xxx" joined onto another table
I am trying get a list of items (to eventually be deleted). My inner select returns the following items from the collections table (which is correct).
I want to use the above results to to join on th...
Get Off My Lawn
Votes: 0
Answers: 1
SQL sum the number of satisfied conditions and compare with other column
I want to check for three columns if a certain condition holds. Next, I want to sum these three booleans and check whether they are the same as a value in a fourth column.
SELECT SUM(CASE WHEN column1...
HJA24
Votes: 0
Answers: 1
T-SQL -- faster way to do match for NOT LIKE '%[^0-9]%' used in CASE/WHEN statement
I am looking for a potentially faster way to do this check:
NOT LIKE '%[^0-9]%'
This checks to ensure all characters are numbers (see description of T-SQL pattern)
Is there a faster way to do this in...
JosephDoggie
Votes: 0
Answers: 1