Tag: select

Postgres where clause over two columns from subquery

postgresql select sql subquery where-clause

Database: Postgres Table name: records Has 4 columns Year | Dept | Expense | Month So per year there can be up to one record for each month / per department. I have a sub-query which returns me …

using conditional where clauses in mysql select statement

mysql select sql

There is a stored procedure sp_select_from_persons in MySql. And there are 3 parameters inside this procedure. age, class, group. These parameter values can be -1 or another value. And these …

How to compare two columns in the CASE statement

select sql

I have two columns Speed_A and Speed_B. Now I will compare both columns and will select the higher one in a new table. Something like this: How does it work? Answer Assuming your speeds are numerically typed you might get this as easy as: Your ELSE will only occur, when A and B are equal, In this case it doesn’t

Can we write case statement without having else statement

case select sql sql-server sql-server-2008

I have this query: It is giving me o/p as Id A B NULL NULL NULL I don’t want to have NULL values in my output, I only want to compare in A and B, is it possible in case statement. Answer A case expression can only manipulate the value of an expression, not remove rows from the result. If

MS access Data type mismatch in criteria expression c#

c# ms-access select sql

I have error, i want to do a filter, which consist some combobox and datetimepicker and it’s will be show in dategridview. And when i want select date from datebase, i have this error: “Data type …

How to use order by on a calculated field in SQL?

select sql sql-order-by sql-server-2008 tsql

How to use order by on a calculated field in SQL? This is giving me ‘Total1’ column does not exist but as you see I have created it and is working if I am not using the order by clause. Answer You can do what Mureinik suggests and use the ordinal notation of ORDER BY 13, which means “order by

Spark SQL passing a variable

select sql

I have following Spark sql and I want to pass variable to it. How to do that? I tried following way. Answer You are almost there just missed s 🙂

how i can select records with varbinary type?

select sql sql-server

I have table in my database that has two column namely data and length. I declare data as a VARBINARY(MAX) and suppose the table has a record with length equal to 5 and data = 0x23 0x00 0x12 0x45 0x34. Table definition: The question: Is it possible to search (with a SELECT query) to find records that has 0x00 0x12

SQL: Two select statements in one query

select sql

I want to select information from two SQL tables within one query, the information is unrelated though, so no potential joints exist. An example could be the following setup. tblMadrid tblBarcelona I want to have a query that gives me the following: I tried to follow this logic: Multiple select statements in Single query but the following code did not

SQLite database – select the data between two dates?

select sql sqlite

I want to select my data by date – from a date until another date, so I have this query, But this query only return the data in ‘2014-10-09’, excluding the data in ‘2014-10-10’, unless I change the query to this below, This is not an ideal solution. How can I select the data including the data in ‘2014-10-10’? NOTE: