SQL queries the previous and next records of the current data

Mssqlserver query method

In fact, the simplest way is to write the following code:

The code is as follows:	Copy code
SQL statement of the previous record: Select top 1 * from news where newsid <id order by newsid DESC The SQL statement of the next record: Select top 1 * from news where newsid> id order by newsid ASC

Another write failure

Id indicates the news_id parameter of the current data.

Method 1:

The code is as follows:	Copy code
String preSql = "select top 1 * from news where news_id <" + id + "order by news_id DESC" String nextSql = "select top 1 * from news where news_id>" + id + "order by news_id ASC"

Method 2:

The code is as follows:	Copy code
String preSql = "select * from [news] where news_id = (select MAX (news_id) from [news] where news_id <" + id + ")"; String nextSql = "select * from [news] where news_id = (select MIN (news_id) from [news] where news_id>" + id + ")";

Mysql Query method

If the ID is a primary key or has an index, you can directly find it:
Method 1:

The code is as follows:	Copy code
1. select * from table_a where id = (select id from table_a where id <{$ id} order by id desc limit 1 ); 2. select * from table_a where id = (select id from table_a where id> {$ id} order by id asc limit 1 );

Method 2:

The code is as follows:	Copy code
1. select * from table_a where id = (select max (id) from table_a where id <{$ id }); 2. select * from table_a where id = (select min (id) from table_a where id >{$ id });

I haven't figured out any other superior products yet.