Top "Select" questions

How to select into a variable in PL/SQL when the result might be null?

Is there a way in to just run a query once to select into a variable, considering that the query …

select plsql

MySQL select with CONCAT condition

I'm trying to compile this in my mind.. i have a table with firstname and lastname fields and i have …

mysql select conditional-statements where concat

Best way to unselect a <select> in jQuery?

<select size="2"> <option selected="selected">Input your option</option> <option>Input your …

jquery select

MySQL case insensitive select

Can anyone tell me if a MySQL SELECT query is case sensitive or case insensitive by default? And if not, …

mysql select

How to select only the first rows for each unique value of a column

Let's say I have a table of customer addresses: CName | AddressLine ------------------------------- John Smith | 123 Nowheresville Jane Doe | 456 Evergreen Terrace John …

sql sql-server tsql select unique

How do I combine 2 select statements into one?

I am a noob when it comes to SQL syntax. I have a table with lots of rows and columns …

sql select conditional

How to select bottom most rows?

I can do SELECT TOP (200) ... but why not BOTTOM (200)? Well not to get into philosophy what I mean is, how …

sql sql-server database select keyword

Select objects based on value of variable in object using jq

I have the following json file: { "FOO": { "name": "Donald", "location": "Stockholm" }, "BAR": { "name": "Walt", "location": "Stockholm" }, "BAZ": { "name": "Jack", "location": "…

json bash select jq

INSERT INTO...SELECT for all MySQL columns

I'm trying to move old data from: this_table >> this_table_archive copying all columns over. I've tried …

mysql select insert-into

MySQL Query - Records between Today and Last 30 Days

I want to return all records that were added to the database within the last 30 days. I need to convert …

mysql date select