Linked Questions

Question 1

I have a complex query that does multiple matches across multiple columns and then orders by relevance. Everything works fine UNTIL I add WHERE 'rank' > 0 This then returns an empty results set. ...

Question 2

SELECT mob_no, (SELECT max(str_to_date(debit_date,'%d/%m/%Y')) FROM client_debit_bal WHERE mob_no='".$mobno."') AS date, sum(debit_amt) AS debit FROM client_debit_bal WHERE date_format(...

Question 3

SELECT zlec_status.nazwa AS Status, piorytet.nazwa AS Priorytet, Concat(koord.imie, ' ', koord.nazwisko) AS `Koordynator`, Concat(...

Question 4

SELECT VoteTypeId AS vcol FROM VoteType v WHERE v.VoteTypeId = 4 and table structure is vcol VoteType ----------- -------------------------------------------------- 1 Yes/No 2 ...

Question 5

I am receiving an error during my age calculation. Here is my query: SELECT (YEAR(CURDATE()) - YEAR(STR_TO_DATE(birthdate, '%m/%d/%Y'))) age, name FROM pers WHERE age >= 50 ORDER BY age DESC ...

Question 6

I've upgraded from MySQL 5.5 to 5.7 and I have a query that no longer works. It's quite a big one but I've reduced it down to this - the query itself doesn't really make sense but demonstrates: ...

Question 7

To have students (student_id, course_id, course_name) who take exactly only one course, using a simple SQL statement with no sub-query and no join at all student_id course_id course_name ----------...

Question 8

How to filter data in the below query using where clause for Balance column. I'm getting the error [Unknown column "Balance" in "where clause"] when i use Balance in where condition. select *,(it....

Question 9

Newbie to sql here. I am trying to select only tuples whose values in one column are larger than the average of that column. The problem is, the relation I am working with is created in the FROM ...

Question 10

If I run below query in my phpmyadmin it throw me below error > Error in query (1054): Unknown column 'QTY' in 'where clause' SELECT User_Name, COUNT(User_Name) AS QTY FROM preusage WHERE ...

Question 11

I am trying to do an SQL query to get all the messages sent between 2 users: the "Sender" and the "Reciever" (yes I know this is spelled wrong) are foreign keys to the Users table. I want to get back ...

Question 12

Why this query is not returning data of 2011 and 2012. Can anyone help me out.Thanks in advance. SELECT country_code, SUM(`attendance`) as k6_attendance, count(*) as total_events , ...

Question 13

Question 14

Is it possible to use an alias in a WHERE condition? For example: SELECT n.name, count(c.name) as freq FROM names as n, names as c WHERE freq < 1 AND gender = 'f' order by rand() ) Or would I ...

Collectives™ on Stack Overflow

Linked Questions

MySQL CASE WHEN where clause causes failure

How to use alias variable for condition in mysql?

Where statement that will use a concat

Innodb problem . The sql query with alias is not working

Age calculation not working [duplicate]

MySQL 5.7 - aggregate function breaks referencing column alias in subquery

Sql query without sub query and joins

Filtering data from joined mysql table using Where Clause

Reference a FROM alias in HAVING

I dont understand what I did wrong

How to do a "where" clause on data from join

Sql Query not working?

query 1 to Many in one record with filter in MariaDB

Using a named count() function in sql where section

Hot Network Questions