Top "Select" questions

Select is a common keyword used to query data.

Changing selection in a select with the Chosen plugin

I'm trying to change the currently selected option in a select with the Chosen plugin. The documentation covers updating the …

javascript jquery select jquery-chosen
MySQL - sum column value(s) based on row from the same table

I'm trying to get 'Cash', 'Check' and 'Credit Card' totals in new columns based on ProductID from the same table. …

mysql select group-by left-join pivot
Add row to query result using select

Is it possible to extend query results with literals like this? select name from users union select name from ('JASON'); …

sql sql-server tsql select insert
AngularJS - value attribute for select

Source JSON data is: [ {"name":"Alabama","code":"AL"}, {"name":"Alaska","code":"AK"}, {"name":"American Samoa","code":"AS"}, ... ] I try ng-options="…

select angularjs options
Mysql SELECT CASE WHEN something then return field

I have two field nnmu and nnmi , if nnmu is equal to 1, I need to return naziv_mesta from **mesto_…

sql select mysql case
Right click to select a row in a Datagridview and show a menu to delete it

I have few columns in my DataGridView, and there is data in my rows. I saw few solutions in here, …

c# select datagridview contextmenu right-click
SQLite select where empty?

In SQLite, how can I select records where some_column is empty? Empty counts as both NULL and "".

sql sqlite select isnullorempty
CodeIgniter: How to use WHERE clause and OR clause

I am using the following code to select from a MySQL database with a Code Igniter webapp: $query = $this->…

mysql select codeigniter where-clause
Select specific row from mysql table

Ideally I need a query that is equivalent to select * from customer where row_number() = 3 but that's illegal. I can't …

mysql select row-number