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
There is a mysql query, and I need to implement it in a postgresql query. create table objects( object_id int NOT NULL PRIMARY KEY , city_id int not null , p
I have this kind of date table: I want to find/detect all blank dates between them, or showing how many days it skipped. I tried: SELECT date FROM tbl_attenda
I am trying to insert a data frame row in a mysql table, but I have NA values in character and numeric columns. I'm getting this error: Error in .local(conn, st
When I passing parameters a1 as "a1", a2 as ["a21","a22"] @Query(value = "select * from a where if(:a1 !='', a1=:a1,1=1)" + "and if(:a2 !='',a2 in (
I have 2 tables with entries as: Transition table: From_Status_Id To_Status_Id PU_Id 5 1 868 5
SQL Noob here. I'm struggling with a (hopefully) simple SQL query and would appreciate if someone could help me understand if what I'm trying to do is even poss
I have one query result as: Wname NewCases Mon 2 Tues 1 Sat 3 Second query result as: Wname FollowUp Tues 3 Wed 4 Frid