Skip to content

Tugrul ASLAN

  • Home
  • Software Engineering
  • About

Getting the first and last records of a table

Reading Time: < 1 minute

First record

SELECT * 
FROM    TABLE
WHERE   ID = (SELECT MIN(ID)  FROM TABLE)

Last record

SELECT * 
FROM    TABLE
WHERE   ID = (SELECT MAX(ID)  FROM TABLE)
Share this content @ Share on FacebookShare on LinkedinShare on XingShare on TwitterShare on PinterestShare on Reddit
Author tugrulaslanPosted on June 3, 2014August 7, 2018Categories SQL&Database

Post navigation

Previous Previous post: installing IntelliJ on Ubuntu
Next Next post: Changing Jboss 7.1 port

Categories

  • Algorithms (8)
  • Android (2)
  • Application Servers (12)
  • Architecture (1)
  • Best Practices (1)
  • Data Structures (5)
  • Design Patterns (5)
  • Frontend Development (6)
  • Hibernate (5)
  • Java (81)
  • Java Server Faces (23)
  • Linux&Unix (19)
  • Maven (9)
  • Operating Systems (23)
  • Spring (14)
  • SQL&Database (21)
  • Testing (8)
  • Version Control (2)
  • Windows (3)
  • ZK Framework (6)

Search in blog

Tag Cloud

  • adapterdesignpattern (1)
  • adapterpattern (1)
  • arraylist (1)
  • bubblesort (1)
  • collections (1)
  • css (1)
  • data structures (1)
  • datastructures (5)
  • designpattern (2)
  • designpatterns (1)
  • designpatternsinjava (1)
  • equals (1)
  • hash (1)
  • hashcode (1)
  • hashcollision (1)
  • hashmap (2)
  • hashtable (1)
  • immutability (1)
  • immutableobjects (1)
  • java (2)
  • javainstallation (1)
  • jdk (1)
  • js (1)
  • jsf (1)
  • linkedarraylist (1)
  • linkedhashmap (1)
  • linkedhashset (1)
  • list (1)
  • map (1)
  • maven (1)
  • mediatorpattern (1)
  • object (2)
  • oraclejava (1)
  • pattern (1)
  • postgresql (1)
  • quicksort (1)
  • resources (1)
  • selectionsort (1)
  • set (1)
  • sorting (8)
  • sortingalgorithm (8)
  • testing (2)
  • treemap (1)
  • treeset (1)
  • vector (1)

Recent Posts

  • Setting Environment Variables in Linux
  • Event Sourcing and CQRS
  • Spring Cloud – Rabbit MQ Comprehensive Glance
  • Exception Testing
  • IBM AMQP

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org
  • Home
  • Software Engineering
  • About
Tugrul ASLAN Proudly powered by WordPress