Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 236
  • Last Modified:

HoW to select the last row of a table ?

HoW to select the last row of a table in SQl Base 7?
What's the syntax?
0
nk51
Asked:
nk51
1 Solution
 
cymbolicCommented:
What is the last row of a table?  Is it the last one written, or is it the last one physically placed on the last allocated page?  I am not being rhetorical.  In this environment, "Last" row does not have a precise meaning.  If you mean the last one created, or last one updated, then you can use a timestamp column and select the row with the max() value on that column, otherwise you need to figure out how to mark and retrieve the last row in your own terms.
0
 
odessaCommented:
What do you mean last, last in witch order, by WHAT?
0
 
cymbolicCommented:
p.s. autonumber columns are also a good method to select last one created.
0
What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

 
nk51Author Commented:
Sorry, I'm french so my english is bad.
I'm searching how to select the last created row of a table.
This table is sorted by increase order on a primary key (column_name).
I only wanted to know if a  similar syntax as this ACCESS requete exist in SQLBAse7 :
select last(column_name) from table_name
???
0
 
mitekCommented:
Here is an answer.
One way in SQL Server is:

DECLARE @last_key varchar(255) -- or int, or whatever

-- this will select the last primary key to a variable
SELECT @last_key = column_name
  FROM tab ORDER BY column_name

-- this will select the last row by that key
SELECT * FROM tab WHERE column_name = @last_key


0
 
nk51Author Commented:
To cymbolic :
I work an a table on which I can't add a column.
My first question was wrong writed.
I use Delphi 3.0 to ask a SQLbase 7 Database.
And I only want to know if it exist a direct SQL expression to select the last one created.

To mitek :
I can't use a variable because I'm using Delphi 3 to ask a SQLbase 7 database.
0
 
JCresonCommented:
You can use the MAX(Key_Field_Name) aggregate function to get you to the right row, if your Key_field is numeric or a date.  However, if your key is text you will have to sort first.

Try SELECT * From Table 1 WHERE Key_Field_Name
                 = (SELECT MAX(<Key_Field_Name>) from Table1)

Good luck
0
 
nk51Author Commented:
Max is a good solution.
Thanks.

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now