checking for a value existence in table sql

Question

i am writing a query like below to retrieve a specific value from the table based the certain value.

select name from XXX where number="2033"

this query will search in whole table. Now i want this query should only check from 4th row to last row and return me the result . that means even if the value is present in 2nd row also it should return me null value or blank value

Please check the below link this might be helpful for you https://stackoverflow.com/questions/29894645/how-to-skip-the-first-n-rows-in-sql-query — Vijay Thikkisetti, Nov 24 '17 at 06:57
When we talk about row number, it should be associated with order, so what is your order column. — Blank, Nov 24 '17 at 06:58

score 1 · Answer 1 · answered Nov 24 '17 at 07:02

I think this will do the trick.

select
    name
from (
    select
       *,
       @rowno := @rowno + 1 rowno
    from XXXX
    cross join (select @rowno := 0)
    order by some_col) t
where rowno >= 4
and number = '2033'

Or without subquery:

select
   name,
   @rowno := @rowno + 1 rowno
from XXXX
cross join (select @rowno := 0)
where number = '2033'
order by some_col
having rowno >= 4

score -1 · Answer 2 · edited Nov 24 '17 at 07:08

-1

you can write the query as below :

select 'name' from XXX where number= "2033" order by id desc limit 0,4;

edited Nov 24 '17 at 07:08

Anandhu Nadesh

672
2
11
20

answered Nov 24 '17 at 06:52

Rajv

1

checking for a value existence in table sql

2 Answers2