We have started a new project in .NET Core. We are just starting out and we are hitting a Web API endpoint to get some reference data of 8 records. We noticed
Assume I have a table like this id cnt tier 1 100 gold 2 200 silver 3 300 bronze 4 400 bronze 5 500 bronze 6 600 gold 7 700 silver 8 800 silver 9 900 silver 10
Samantha was tasked with calculating the average monthly salaries for all employees in the EMPLOYEES table, but did not realize her keyboard's key was broken un
I have a question in term of my database courses, hope that you can help me. The table bellow is an exemple: +------------------------------------+ |ID_EMPLOYEE
The sql conditional sum statement below keeps throwing me an error and I'm not sure why. The logic should create a flag when any of the underlying flags are 1,
The goal is to achieve the selected columns in SQL based on the some manual classification of the fields, e.g. from dataclasses import dataclass @dataclass cl
I need to create a Trigger to monitor this table : CREATE TABLE "REFERENCE" ( "NUM_CONTRACT" VARCHAR2(20 CHAR), "NATURE" VARCHAR2(20 CHAR),
See I dont want any mapping but what I want is just a simple thing that is.... I have two Entity Tasks(taskid,taskname.....,userId) User_Credentials(userId,pass
Hi I have this three very simple tables but I can't fix it to get the right format of foreign key. CREATE TABLE company( company_name varchar(30) UNIQUE NOT NUL
I have a table with users: id referred_by_user_id ----------------------------------- 1 null 2 1 3 1 4
I want to iterate over all the columns using dbt.
The passwords and my SQL database are hashed. If the input is hashed, can the field be injected? The hash is SHA256. My command is to be: SELECT true FROM acc
thanks for reading and provide any suggestions or any keyword I can do more research. Quite new to TypeORM and have an issue on searching the tree structure wit
as it says in the title, I need to return two records but in the same column, for example (I clarify that the following code does not work, it is only to unders
What is the shortest Pgsql query to get all records that contain a line-break in a given column ?
I have the below data in my sql server table Name Value ValueHash country aaa zzz lastname ccc yyy email [email protected] xxx firstName bbb www And I want the below Js
Suppose I have a table that looks like this: OrderNumber OrderType 1 D 1 D 1 R 2 D 2
Here is my query: SELECT DISTINCT takes.semester, takes.sec_id, takes.course_id, instructor.name, COUNT(takes.ID) FROM takes INNER JOIN teaches ON takes.cour
I am planning out an application's database. I have an employee table. I want to store every employee's education degree. Adding an education column to the empl
I have 2 tables projects and images. My goal is to get all images of a project and get this kind of response. { "data": { "id": "this is project id",