Logo
  • Home
  • About
  • Services
  • Blogs
  • Career
  • Contact
Logo

The UK's #1 Software Development Company. PodTech IO builds custom software solutions for businesses. Call today for a free consultation

  • Address

    4th Floor, 4 Tabernacle Street London EC2A 4LU
  • Email

    info@podtech.com
  • Contact

    +44 (0) 20 8720 6583

Select the next available value in a table

  • Home
  • Select the next available value in a table
  • By podtech
  • In SQL

Select the next available value in a table

Let’s say I have a table like this:

ID Value
———————-
100 val1
101 val2
104 val3
105 val4
107 val5

[sql]
SELECT Min(r1.uid) + 1 AS next_available_uid
FROM unixuid AS r1
LEFT OUTER JOIN unixuid AS r2
ON r2.uid = r1.uid + 1
WHERE r1.uid > 200
AND r2.uid IS NULL

[/sql]

Select the next available value in a tableSQL
ASHRAE
Get HTTP Code Response – Perl

Recent Posts

  • DevOps as a Software Development Methodology
  • How Does Spiral Software Development Methodology Work?
  • Waterfall Software Development Methodology And When To Use It
  • What Exactly Is Lean Software Development Methodology?
  • What is Kanban and How Does It Work?

PodTech IO

The UK's #1 Software Development Company. PodTech IO builds custom software solutions for businesses. Call today for a free consultation

Company

  • About
  • Services
  • Contact
  • Blogs
  • Career

Terms

  • Terms & Conditions
  • Privacy Policy

Contact Us

  • ADDRESS

    Headquarter: Tabernacle Street London India: Vi john Tower, Gurgaon, Haryana
  • EMAIL

    info@podtech.com
  • CONTACT

    +44 (0) 20 8720 6583

Copyright ©2023 PodTech IO. All Rights Reserved

Logo