I have Database table called tbl_emails like this id email 1 [email protected] 2 [email protected] 3 [email protected] 4 [email protected] 5 [email protected] 6 [email protected] 7 [email protected] 8 [email protected] 9 [email protected] 10 [email protected] I have about 5000 rows in the table. Now What…
I have 2 tables. A Users table and a Token table. I am trying to join these tables to see who has verified their tokens and who hasn't. The token table has a foreign key with the user id in…
I have the below table - assume tags column always have top level string keys: name(TEXT) | tags(jsonb) -----------+------------------------------------------------------- teamA | {"color": "green", "zone": "primary"} teamB | {"color": "green", "zone": "primary", "role": "user"} teamC | {"uid": "32-232-2dswdwsd", "availability": "condensed"} Let's…
Doing self join with same table with range condition. The below is sql statement. select current_rec .* ,compare_rec.employee_id as less_salary_employee from hr.employees current_rec left join hr.employees compare_rec on current_rec.hire_date < compare_rec .hire_date and current_rec.salary < compare_rec.salary order by current_rec .employee_id…
i have a webapplication in .net and use a DetailsView. im control this DetailsView with a SqlDataSource. i set a session with jquery. <script > var baseUrl = (window.location).href; var clubid = baseUrl.substring(baseUrl.lastIndexOf('=') + 1); sessionStorage.setItem("se", "13801"); var ses =…
I have an old PHP5 MySQL webapp whose code had to be adapted to PHP8/MySQL14.14 There's a view, querying few tables and based on that code: (SELECT `db_demandes`.`bdd`.`id` AS `Id`, `db_demandes`.`bdd`.`ref` AS `Ref`, `db_demandes`.`bdd`.`nodossier` AS `NoDossier`, `db_demandes`.`bdd`.`agentfirme` AS `Agentfirme`, `db_demandes`.`bdd`.`agentanterieur`…
I have a table that looks something like this: id colors other column other column 1 red, green, blue ... ... 2 red, blue ... ... 3 red ... ... 4 white, blue, purple ... ... 5 green, white, purple…
Consider the following example: There are 3 tables: clients (1) -> (n) orders (1) -> (n) order_updates. I want to update clients based on the corresponding order_updates with JOIN (which produces duplicates for clients data): UPDATE "clients" SET "clients"."status" =…
I have the following query: SELECT users.uuid FROM users JOIN users_ext ON users.uuid = users_ext.uuid WHERE TRUE AND ($1 IS NULL OR users.country IN (ARRAY[$1])) AND ($2 IS NULL OR users.bonus_points IN (ARRAY[$2])) AND Although I am getting the error:…
I'm using snowflake. This is my statement: select PARSE_JSON(src): "eventType"::STRING AS eventtype, PARSE_JSON(PARSE_JSON(src): "data"::STRING): "events" AS events, PARSE_JSON(PARSE_JSON(PARSE_JSON(src): "data"::STRING): "events"): "actor" AS actor, PARSE_JSON(PARSE_JSON(PARSE_JSON(PARSE_JSON(src): "data"::STRING): "events"): "actor"): "actor" AS actor2, PARSE_JSON(PARSE_JSON(PARSE_JSON(src): "data"::STRING): "events"): "client" AS client, * from stage.okta_events This…