Suppose my MySQL database has 50 records and my query is as:

select distinct(l.sno), c1.cname source, c2.cname dest, c3.cname protocol, l.dest_port
from Log l, Objects o1, Component c1, Objects o2, Component c2, Services s, Component c3
where ((l.source_ip=o1.objlowip) and (c1.cid=o1.objid))
and ((l.dest_ip=o2.objlowip) and (c2.cid=o2.objid))
and (((l.dest_port=s.supp && slowp) and (l.protocol=s.protocol)) and (s.sid=c3.cid))
order by sno desc limit 2,10;

It will display the 10 records starting from last and leaving last 2. But if I want to display 10 records before sno=48 i.e. by specifying sno in my query. How can I modify my query i.e. how can I specify sno.

Have you tried using a (sno < 48) in your where clause?


Take care,

Nik
http://www.bigaction.org/

Sir,
Ur query i.e. by applying sno<48 gives bulk values and also it does not correctly apply order by clause.
Thanx

I'm not quite sure I follow what you mean... you're linking all the tables (l, s, c1, and c2) by various columns, so limiting the rows from l where l.sno < 48 should just reduce the final result set returned after linking all the remaining rows. The ORDER BY clause sorts the final results of a query, and said sorting should really be done after that final result set is determined; i.e. AFTER the (l.sno < 48) row filter is applied.

So, i guess my question to you is, what query did you try, exactly, and what was wrong with your results?

If you need further assistance, perhaps you can dump the structure and contents of your tables, and perhaps give a more detailed description of the result set you want so that we can figure out your query.


Take care,

Nik
http://www.bigaction.org/