Skip site navigation (1) Skip section navigation (2)

Get the last record alone from the select statement.

From: HK <harikrishnan(at)midascomm(dot)com>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: Get the last record alone from the select statement.
Date: 2003-07-25 05:47:13
Message-ID: Pine.LNX.4.33.0307251114360.2680-100000@mallard.midascomm.com (view raw or flat)
Thread:
Lists: pgsql-novice
Hi all,
  I have a doubt in limit clause. With limit and offset i can get the 
first few records from the select statement. Suppose i want to get the 
last record alone from the select, how can i achieve it.
I know this would have been answered many times, but i was not able to go 
thru the archieves.
Plz help me.

-- 
regards,
hari
      __
     / /    __  _  _  _  _ __  __         -o) 
    / /__  / / / \\// //_// \\ \\/ /         /\\\\  Making things happen
   /____/ /_/ /_/\\/ /___/  /_/\\_\\        _\\_v-  

-------------------------------------------------------------------


Responses

pgsql-novice by date

Next:From: Jim LouisDate: 2003-07-25 07:13:27
Subject: Where's The Primary Key?
Previous:From: Jay RDate: 2003-07-25 03:31:04
Subject:

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group