How to range ID from 1 to 5 and 10 to 6 in one SQL statement

Answer 1

Answer to Is it possible to reverse ID (primary) in the database with auto increment so that it will always make the newest row's ID 1 automatically? by Mark Twaine https://www.quora.com/Is-it-possible-to-reverse-ID-primary-in-the-database-with-auto-increment-so-that-it-will-always-make-the-newest-rows-ID-1-automatically/answer/Mark-Twaine?ch=15&oid=42922425&share=3c4f9dce&srid=u79FBS&target_type=answer

Answer 2

Maybe he wants a result like this
1, 2, 3, 4, 5, 10, 9, 8, 7, 6

I honestly don't know if it's possible without subqueries

Answer 3

Rupali Thanks so much 🙏

Answer 4

You're welcome :)

Answer 5

SELECT columnName FROM tableName WHERE id >= 1 && id <= 5

SELECT columnName FROM tableName WHERE id <= 10 && id >= 6

Answer 6

Yes Nick I need result as you said

Answer 7

Im writing in SSMS