|
View previous topic :: View next topic
|
| Author |
Message |
aryanpa1
New User
Joined: 26 May 2007
Posts: 45
Location: Chennai
|
|
|
|
Hi ,
Can any body suggest me to retrieve the first row from a table in efficient way.
Thanks,
pavan |
|
| Back to top |
|
 |
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
Hello,
What is meant by "first row"?
Sequential files have a first and last record, but databases do not have the same.
Keep in mind that most database processing is done via one or more keys. There is no "first". |
|
| Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006
Posts: 6250
Location: Mumbai, India
|
|
|
|
Pavan,
This can be one way:
| Code: |
SELECT * FROM table Name
FETCH FIRST ROW ONLY
WITH UR; |
|
|
| Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
Hello,
That will fetch one record - not sure i understand how that would be "the first row from a table"  . It would be the first row that particular query fetches, but that does not imply the first row in the table.
As i mentioned earlier, until what "first row" really means is defined, there is no way to read it and besides, there is not a "first row in the table" concept in most database systems. |
|
| Back to top |
|
|
aryanpa1
New User
Joined: 26 May 2007
Posts: 45
Location: Chennai
|
|
|
|
Hi Anuj ,
It worked. Thankyou... |
|
| Back to top |
|
|
stodolas
Active Member
Joined: 13 Jun 2007
Posts: 632
Location: Wisconsin
|
|
|
|
| Code: |
SELECT * FROM table Name
FETCH FIRST ROW ONLY
WITH UR; |
Is extremely useless. You just arbitrarily selected a row. It could be different the next time you do it, or it could be the same for the life of the table.
This is a complete waste of a query without a ORDER BY clause. |
|
| Back to top |
|
|
|
|
