Display id, name, manager id and manager name of those employees who are allocated a computer and whose manager is also allocated a computer. Also display the m
I tried to calculate the difference between dates in months for a huge database, using dbplyr package which sends my codes to the sql query. I tried different w
I am struggling with query logic. I have two tables, e.g. Table1: A B 0 1 0 2 1 1 1 2 Table2: A B C 0 0 a 0 1 b 0 2 c 1 0 d 1 0 e 1 1 f 1 2 g I need to left
I am trying to figure out where my query is failing on a where clause, I hope some of the local experts could point it out and explain why. Also I would like to
I am trying to write an sql command that enters a password inside a string. The database entry that I need changed is in the users table preferences column and
I have two tables city and house (foreign key to house), I need get result true if city's all houses has property has_door = true.
I have a table in the following format Name|Token| Date | --------------------- John|7 |2010-4-30| John|7 |2011-4-30| John|9 |2011-5-30| John|9 |
I'm working on Odata V4 and want to use groupby clause to get data from OData svc API.But its not working .getting below error HTTP/1.1 400 BadRequest Content-
In my models.py few models related to the different entities class GuardSecurity(models.Model): id = models.UUIDField(primary_key=True, default=uuid.uuid4,
how should i return this command in c# ? SELECT COUNT(id_pac) AS Expr1, data FROM programare GROUP BY data private void button1_Click(object sender, EventA
I am having trouble trying to delete a row by Id. I display every row of my db in a table and next to every row I have a button that should be used for deleting
Here is my sql: create table student( id smallint primary key auto_increment, class_id smallint not null , name varchar(10) not null , birthday
I am trying to use a postgreSQL INSERT query with a subquery as parameter value. This is to find the corresponding user_id from an accompanying auth_token in us
I have the following table that is comparing two similar tables: Source Part Info 1 Info 2 ... Info 12 Description Color Table 1 Wheel Circle ... Long Distanc
I'm creating a Python script to insert some records in a table, but have the following problem: INSERT INTO orders VALUES (7656940929251, "ADIDAS | KID'S STAN
I'm trying to get the row number of records in my database table, I'm using a variable and am executing the query, I get no errors, but get a null column for nu
Employee_table Id FirstName LastName Division 1 John Smith A 2 Emily Jones B 3 John Smith B 4 John Snow A 5 John Smith C I want to move all duplicate names fr
I have a table like this, id date start end product result 10 2022-06-10 2022-02-10 2022-06-12 183 TRUE
Using SQL I have | Message_From | Message_To |Message| Message_Time(Current TimeStamp)| | -------------| ------------|------ | -------------------------------|
I'm looking for a solution where the database schema and data are maintained in xml or in some file format, so that the db schema and the data