select Questions
3
Solved
I have an array column and I would like to get first N elements of it (keeping an array data type). Is there a some nice way how to do it? Ideally without unnesting, ranking and array_agg back to a...
Begot asked 5/11, 2019 at 14:4
5
Solved
If I wanna replace the options
<option value="A">Apple</option>
<option value="B">Banana</option>
in the given example by the use of an array in a react...
35
Solved
I want to query the list of CITY names from the table STATION(id, city, longitude, latitude) which have vowels as both their first and last characters. The result cannot contain duplicates.
For th...
5
I am trying to get the text value from a dropdown select using {useState} in React Hooks. I just get the value (number) rather than the text.
I've copied the bits of code below which control the se...
Sclater asked 26/9, 2019 at 10:32
7
Here is the markup
<select id="person_prefix" name="prefix">
<option value=""></option>
<option value="Dr" selected="selected">Dr</option>
<option value="Mr"&g...
Calcine asked 2/10, 2010 at 17:14
12
Solved
Is it possible to do a select statement that takes only NOT NULL values?
Right now I am using this:
SELECT * FROM table
And then I have to filter out the null values with a php loop.
Is there ...
3
Solved
I have a dataframe
import polars as pl
import numpy as np
df = pl.DataFrame(
{
"nrs": [1, 2, 3, None, 5],
"names": ["foo", "ham", "spam", "...
Heathenry asked 12/2 at 14:11
8
Solved
Using SQL Server 2008, say I have a table called testing with 80 columns and I want to find a value called foo.
I can do:
SELECT *
FROM testing
WHERE COLNAME = 'foo'
Is it possible I can query a...
Goodden asked 25/2, 2015 at 11:29
8
Solved
If I have this code:
<select onchange="alert('?');" name="myname" class="myclass">
<option isred="-1" value="hi">click</option>
</select>
How can I get the value '-1'...
Dink asked 14/8, 2012 at 17:32
4
Solved
4
Solved
I've written this code to find duplicates and it works fine:
SELECT *
FROM StyleTable
GROUP BY Color
HAVING count(*) > 1
The problem is, it's returning just one of the duplicate rows. Is it...
Landscapist asked 5/3, 2012 at 22:12
4
Solved
I have a WPF ComboBox and I want to go to items that start with (for example) "e" in the ComboBox when I type that letter. How?
My XAML code:
<ComboBox ItemsSource="{Binding Roles}" SelectedVa...
5
Solved
I'm quite new to database programming and I am wondering what the negative effects of indexes are? As far as I understood, indexes speed up operations which have to search the database for a specif...
6
Solved
I tried the following select:
SELECT (id,name) FROM v_groups vg
INNER JOIN people2v_groups p2vg ON vg.id = p2vg.v_group_id
WHERE p2vg.people_id =0;
And, I get the following error column reference...
Demonstrate asked 22/3, 2012 at 11:9
3
Solved
I wrote the following SQL statement to get data from two tables gendata & TrainingMatrix:
SELECT * FROM (SELECT DISTINCT ON ("TrainingMatrix".payroll, "TrainingName", "...
Fritzfritze asked 14/11, 2013 at 10:53
10
Solved
What's the best way to wait (without spinning) until something is available in either one of two (multiprocessing) Queues, where both reside on the same system?
Optometrist asked 14/7, 2009 at 6:58
9
Solved
I have two tables with one identical column name, but different data. I want to join the tables, but access both columns (row["price"], row["other_price"]): How can I rename/alias one of them in th...
Jesher asked 5/3, 2009 at 10:24
12
Solved
I would like to add some style on a select box with the pseudo :after (to style my select box with 2 parts and without images). Here's the HTML:
<select name="">
<option value="">Test...
6
I've searched all over for this but I can only find how to change/modify styles for input, select and button elements.
What I want to do is remove all shadows, borders, background, icons etc every...
5
Solved
I've been using PostgreSQL and now migrating to MySQL.
In my queries, I'm using PostgreSQL's SELECT DISTINCT ON (col1, col2, col3), I was wondering if there is any counterpart of this statement i...
Relativity asked 16/7, 2013 at 9:56
34
Solved
I'm trying to use a select statement to get all of the columns from a certain MySQL table except one. Is there a simple way to do this?
EDIT: There are 53 columns in this table (NOT MY DESIGN)
5
Use the defaultValue or value props on instead of setting selected on .
<select defaultValue="react">
<option value="react">React</option>
<option value="angular">Angular...
Carce asked 5/7, 2016 at 3:10
10
Solved
I need to select rows randomly from an Oracle DB.
Ex: Assume a table with 100 rows, how I can randomly return 20 of those records from the entire 100 rows.
5
Solved
I am trying to select one row in the table and emit the selected item.
Selecting one selects all but only the first encountered object is saved to the model (as selected variable).
Do you have an...
Jaine asked 29/5, 2020 at 11:16
35
Solved
I have a form where a user can add multiple select boxes for multiple cities. The problem is that each newly generated select box needs to have a unique id. Can this be done in JavaScript?
Here is ...
Hartz asked 12/7, 2010 at 19:12
© 2022 - 2024 — McMap. All rights reserved.