Stack Overflow
Stack Overflow

Questions tagged [select-query]

176 questions
327
votes
16 answers

How can I select from list of values in SQL Server

I have very simple problem that I can't solve. I need to do something like this: select distinct * from (1, 1, 1, 2, 5, 1, 6). Anybody can help?? Edit The data comes as a text file from one of our clients. It's totally unformatted (it's a single,…
Eedoh
  • 5,818
  • 9
  • 38
  • 62
130
votes
10 answers

SELECT * FROM tablename WHERE 1

I've been curious. What are the differences between these respective queries: SELECT * FROM `tablename` SELECT * FROM `tablename` WHERE 1 SELECT * FROM `tablename` WHERE 1=1
Stephen Alexander
  • 1,283
  • 2
  • 8
  • 6
86
votes
11 answers

SQL Server PRINT SELECT (Print a select query result)?

I am trying to print a selected value, is this possible? Example: PRINT SELECT SUM(Amount) FROM Expense
Shimmy Weitzhandler
  • 101,809
  • 122
  • 424
  • 632
31
votes
3 answers

Using an IF Statement in a MySQL SELECT query

I am trying to use an IF statement in a MySQL select query. I am getting an error after the AND statement where the first IF. SELECT…
Santosh
  • 2,355
  • 10
  • 41
  • 64
26
votes
8 answers

MySQL floating point comparison issues

I ran into an issue by introducing floating point columns in the MySQL database schema that the comparisons on floating point values don't return the correct results always. 1 - 50.12 2 - 34.57 3 - 12.75 4 - ...(rest all less than 12.00) SELECT…
Sharief Shaik
  • 1,064
  • 5
  • 12
  • 26
15
votes
3 answers

persian/arabic search in sqlite android gives bad result

i have a problem with sqlite database. it seems to not support full persian/arabic characters. when i search some fields based on persian chars, most of the times Sqlite can't recognize those chars. i insert data into database by copy them from HTML…
hojjat reyhane
  • 648
  • 1
  • 8
  • 25
4
votes
2 answers

what will be the select query for excluding empty values in ms access

I am trying select * from table where Contact Is Not null but it is displaying values including empty values
Vampire
  • 320
  • 1
  • 4
  • 10
4
votes
2 answers

Misuse of aggregate function MAX()

I want latest not null value of column ignition_status in Alert table. I have column unix_time which is time in Unix Time Stamp, so max the unix_time column value, latest is the entry. Below is my code cursor = dbUtilsObj.query(Alert.TABLE_NAME,…
Shirish Herwade
  • 11,461
  • 20
  • 72
  • 111
4
votes
1 answer

Wildcard as parameter of stored procedure

Suppose, I have a stored procedure, that accepts one parameter - id, and returns some data corresponding to this id. What if I want to retrieve all such data, like using wildcard in SELECT query? How to do this?
Andrew Vershinin
  • 147
  • 3
  • 3
  • 10
4
votes
3 answers

SQL query confusion for startdate and enddate

I have a table(e.g. tableA) like this: | Name | Startdate | Enddate | |---------------------------------| | a | 2012-07-01 | 2013-06-30 | | b | 2011-05-01 | 2012-04-30 | | c | 2010-01-01 | 2013-12-31 | | d | 2013-01-01 |…
Himanshu
  • 31,810
  • 31
  • 111
  • 133
3
votes
2 answers

MYSQL select query using count (*)

i have a problem concerning a select query in MYSQL i have two different tables and i want to obtain a certain result i used COUNT method which gave me only the results (>=1) But in reality , i want to use all counts with zero included how to do…
holy
  • 632
  • 2
  • 9
  • 18
3
votes
2 answers

PL/SQL - Select columns values as string array

I am not sure if this question is asked anywhere else before. I am not sure how to put it also. But I will explain with a scenario. I have the following tables TAB1 with columns : USERID, CODE, COUNTRY TAB2 with columns : USERID, CODE, EMAIL Example…
Rishi P
  • 249
  • 2
  • 9
  • 20
3
votes
4 answers

Return result of select query only if not empty

Working with Sql Server. Writing a stored procedure. Here is the pseudocode for what I want to achieve: IF EXISTS ( SELECT field1 FROM t1 WHERE field1 = ... AND field2 = ...) BEGIN …
Chirayu Shishodiya
  • 544
  • 2
  • 7
  • 14
3
votes
3 answers

Select data from the last hour, MS Access

I am working on doing some data transfers moving data from one database to another and I would like to do this without using to much memory on the computer that I am running this data transfer program on. Currently the program is ran every minute,…
LaDante Riley
  • 521
  • 4
  • 14
  • 26
3
votes
1 answer

Spark: load or select Hive table of ORC format

I'm trying to load a managed hive table created in ORC format with spark sql. SparkConf conf = new SparkConf().setAppName(ConnectionTest.class.getName()).setMaster(master); JavaSparkContext context = new JavaSparkContext(conf); SQLContext…
josele
  • 97
  • 2
  • 11
1
2 3
…
11 12