oslon

Any books/courses you recommend? I've purchased 5 books on DBMS but they don't seem to teach SQL that much.

t1.abcd=t2.abcd?

CREATE TABLE tableName ( abcd VARCHAR(512), 1.2.3.4 VARCHAR(512), 120 VARCHAR(512), 2024-02-27 09:59:03 VARCHAR(512), VARCHAR(512), VARCHAR(512), VARCHAR(512), VARCHAR(512), VARCHAR(512), VARCHAR(512) ); INSERT INTO tableName (abcd, 1.2.3.4, 120, 2024-02-27 09:59:03, , , , , , ) VALUES ('abcd', '1.2.3.4', '120', '2024-02-27 09:59:00', '', '', '', '', '', ''); INSERT INTO tableName (abcd, 1.2.3.4, 120, 2024-02-27 09:59:03, , , , , , ) VALUES ('efgh', '9.10.11.12', '120', '2024-02-27 09:30:00', '', '', '', '', '', ''); INSERT INTO tableName (abcd, 1.2.3.4, 120, 2024-02-27 09:59:03, , , , , , ) VALUES ('efgh', '9.10.11.12', '120', '2024-02-26 09:00:00', '', '', '', '', '', ''); INSERT INTO tableName (abcd, 1.2.3.4, 120, 2024-02-27 09:59:03, , , , , , ) VALUES ('random', '1ANDOM', 'random', 'random', '', '', '', '', '', ''); INSERT INTO tableName (abcd, 1.2.3.4, 120, 2024-02-27 09:59:03, , , , , , ) VALUES ('random', 'random', 'random', 'random', '', '', '', '', '', ''); INSERT INTO tableName (abcd, 1.2.3.4, 120, 2024-02-27 09:59:03, , , , , , ) VALUES ('', '', '', '', '', '', '', '', '', ''); INSERT INTO tableName (abcd, 1.2.3.4, 120, 2024-02-27 09:59:03, , , , , , ) VALUES ('', '', '', '', '', '', '', '', '', ''); INSERT INTO tableName (abcd, 1.2.3.4, 120, 2024-02-27 09:59:03, , , , , , ) VALUES ('', '', '', '', '', '', '', '', '', ''); INSERT INTO tableName (abcd, 1.2.3.4, 120, 2024-02-27 09:59:03, , , , , , ) VALUES ('', '', '', '', '', '', '', '', '', ''); This is the table. What I want is this. Find only the rows whose A's are same AND B's are same, C=120 and D's difference is less than 3 seconds. How'd I do it? Rather than crude answers, I'd love some guidance (teach a man to fish rather than giving him a fish) I am trying to learn SQL advanced concepts by these practical scenarios in my job where I get less opportunity to use SQL as I am not a data analyst but a support engineer. Any guidance to practice SQL in scenarios like this is also appreciated.

I wonder what might have happened? How do I troubleshoot it? I am a system administrator by profession so I will check logs of application server, but I think I need some tips about database to debug this issue.

while(true) { if(id==1 && counter.length>7) { counter.value=1 } } Application_counter id| counter 1 | 123 Need to convert this to a procedure that runs forever in ms-sql server. How do I do it?

TypeError: arrayOfObjects is not iterable at Object.<anonymous> (C:\Users\User\Desktop\100DAYOFCODE\1\1\script.js:3:19) at Module._compile (node:internal/modules/cjs/loader:1256:14) at Module._extensions..js (node:internal/modules/cjs/loader:1310:10) at Module.load (node:internal/modules/cjs/loader:1119:32) at Module._load (node:internal/modules/cjs/loader:960:12) at Function.executeUserEntryPoint [as runMain] (node:internal/modules/run_main:81:12) at node:internal/main/run_main_module:23:47 The code in question: const arrayOfObjects = require("./data"); for (const obj of arrayOfObjects) { console.log(`ID: ${obj.id}, Name: ${obj.name}`); } data is a file containing stuffs in this order const arrayOfObjects = [ { "id": 1, "name": "bla bla" }, { "id": 2, "name": "bla bla bla" } ]; Any ideas to resolve this issue?

I know not enough information. The web server is of android and ios app. Some users aren't able to login due to this issue and they're getting "ssl error". The logs before the login isn't stored in the server. The web server on nginx is just there for proxy pass and there's nothing significant in nginx's error/access/ssl logs. Except "certain static content not found". If static content not being found was the issue everyone should be getting the same error. I'm wondering for ideas to debug this issue. The server is on glassfish domain.