I wrote sql select array_agg(id) as ids from fff group by a_c_id, a_c_dttm, a_c_code having COUNT(*)>1 which returns results {5,9} {8,12,13} {6,10} {7,11} How to exclude max value in each row for getting this result? {5} {8,12} {6} {7} the…
How can I type the props in the react typescript ? I'm getting the error Property 'authors' does not exist on type '[Props] & { children?: ReactNode; }'.ts. I'm expecting to pass an array wich consists of name and password…
{"SubmitBy":"SK", "Students[0].name":"Jhon", "Students[0].age":"15", "Students[1].name":"Sam", "Students[1].age":"16", "Students[2].name":"Tom", "Students[2].age":15} Result expecting like this {SubmitBy:"SK", Students:[{name:"Jhon", age:"15"},{name:"Sam", age:"16"},{name:"Tom", age:"15"} ]}
Output: My code: let carsArray = [ { make: "BMW", model: "325i", year: 2034, }, { make: "Volvo", model: "540xi", year: 2025, }, { make: "BMW", model: "435e", year: 1994, }, { make: "BMW", model: "X6", year: 2025, }, ];…
I have a payload of an array of objects. Within each object contains a key that has values that are also arrays of objects. I am trying to combine all of the keys that match, and condense down to an…
I am having the following object that is being sent as an object to a function, const mimeTypes = { image: [".svg", ".png", ".gif", ".jpeg", ".jpg"], application: [".pdf", ".zip"], text: [".txt", ".csv"] }; I need to transform the above object…
I created an HTML table containing radio fields using a multidimensional array. How can I get the selected values from the form submission? My current code: $cakedata = array( array("shape" => "Heart", "flavor" => "Chocolate", "toppings" => "Cookies"), array("shape" =>…
I'm trying to transform my table to JSON My table: DROP TABLE IF EXISTS #tmp CREATE TABLE #tmp(AnalyticGoodsT CHAR(6), date SMALLDATETIME) INSERT INTO #tmp(AnalyticGoodsT, date) VALUES ('000001', '20230424'), ('000002', '20230424'), ('000003', '20230424'), ('000004', '20230424') Required JSON format(i'm trying to group…
I have a array as follows : data = [ { "type":"abc", "quantity":36, "code:"EDF" }, { "type":"abc", "quantity":40 "code:"SFDF" }, { "type":"yrf", "quantity":22 "code:"SFDF" }, { "type":"yrf", "quantity":19 "code:"EDF" } ] I want to group elements of this array on…
In PostgreSQL, I have a table named users with data that looks like so: id favorites 1 { "shapes": ["Triangle", "Square"] } 2 { "shapes": ["Rectangle", "Triangle"] } ... ... Where favorites is a JSONB column. I want to add…