sql query for fetching 10 rows with near values

Posted by saurav on Stack Overflow See other posts from Stack Overflow or by saurav
Published on 2010-03-24T15:42:26Z Indexed on 2010/03/24 15:53 UTC
Read the original article Hit count: 310

Filed under:
|

Please help me with writing a sql query - I have a table with id, name and marks columns.

If I arrange the table in ascending order of marks, how can I fetch 5 names whose marks are close to a particular name.

© Stack Overflow or respective owner

Related posts about sql

Related posts about mysql