SQL Query to show records

Question

I am trying to figure out what SQL query I need to fetch records from my users table.

"SELECT * FROM users WHERE level!='4'"

Level 4 users are "COMPLETED" so by default, they are not shown. But I do want to show users that are COMPLETED if their ACTIVITY value is less than 5. Any user with an activity value of 5 is "Green" and does not require my attention.

Knowing my luck, it's a very simple answer, but it's been a long day and my head is fried.

In equality is denoted by <> for most databases. You can use != but it has to be database specific. — Zo Has, Feb 25 '14 at 05:05

score 3 · Accepted Answer · edited May 23 '17 at 12:28

3

You can do like so:

SELECT * 
FROM users 
WHERE level <> '4'
OR (level = '4' and Activity < 5);

I've switched the inequality operator - <> is more portable

edited May 23 '17 at 12:28

Community

1
1

answered Feb 25 '14 at 05:01

StuartLC

100,561
17
199
269

1

Good guess on the schema! – Alex R. Feb 25 '14 at 05:04

cerberus · Answer 2 · 2014-02-25T09:30:36.663

2

This should solve your problem

SELECT * FROM users WHERE level != '4' OR (activity < '5' AND level = '4' )

edited Feb 25 '14 at 09:30

answered Feb 25 '14 at 05:04

cerberus

511
4
14

score 0 · Answer 3 · answered Feb 25 '14 at 05:28

0

simple method like following as:

SELECT * FROM users
LIMIT 4;

answered Feb 25 '14 at 05:28

jmail

5,718
3
18
34

This answer is insufficient – Craigy Craigo Feb 25 '14 at 05:39
@ Craigy Craigo, i didn't understand, why you ask insufficient answer. – jmail Feb 25 '14 at 05:53
@Craigy Craigo, if you have table in 5 rows its should be showing limit is 4. – jmail Feb 25 '14 at 05:55
I'm afraid you do not quite understand the problem. The answer I was looking for is located above. – Craigy Craigo Feb 26 '14 at 02:57
1

@CraigyCraigo, oh k, I'll understand,.. I refer that answer, sorry buddy. – jmail Feb 26 '14 at 03:35

SQL Query to show records

3 Answers3