Solved

sql Next to last Record

Posted on 2006-10-20
8
1,111 Views
Last Modified: 2007-12-19
Greeting

I cant figure out a query that retrieves only the next to last record where the account number = some value  ( not the last record inserted into the dbase)

Im using vb 2005 and access

Any idea's ?

0
Comment
Question by:stephenz43
  • 5
  • 2
8 Comments
 
LVL 12

Expert Comment

by:guidway
ID: 17778825
I think this will work

Select acct_id from [sometableName] where acct_id < [some value] order by acct_id DESC;

then just grab the first record returned and that should be the second to last;
0
 

Author Comment

by:stephenz43
ID: 17778869
hey guidway....

Getting close, but can [some value] be obtained using max[acct_id) ?

steve
0
 
LVL 12

Expert Comment

by:guidway
ID: 17778897
you could try a subquery

Select acct_id from [sometableName] where acct_id < (Select max(acct_id) from [sometableName]) order by acct_id DESC
0
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
LVL 12

Accepted Solution

by:
guidway earned 500 total points
ID: 17778903
should be a semicolon at the end

Select acct_id from [sometableName] where acct_id < (Select max(acct_id) from [sometableName]) order by acct_id DESC;

(this was tested in access, not sure which database you are using)
0
 
LVL 12

Expert Comment

by:guidway
ID: 17778912
oops you said access... sorry. ;)
0
 
LVL 13

Expert Comment

by:newyuppie
ID: 17780580
max function does work in access i believe
0
 
LVL 12

Expert Comment

by:guidway
ID: 17780988
glad it worked for you. :)
0
 

Author Comment

by:stephenz43
ID: 17782540
thank you for the help...You saved me alot of aggravation

take care
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
VB net, code to modify xlsx file, and errors when it is ran on NON-developer PC... 2 39
Store results in vb.net 3 25
Expression Evaluater 3 38
vb.net class 3 22
I think the Typed DataTable and Typed DataSet are very good options when working with data, but I don't like auto-generated code. First, I create an Abstract Class for my DataTables Common Code.  This class Inherits from DataTable. Also, it can …
A while ago, I was working on a Windows Forms application and I needed a special label control with reflection (glass) effect to show some titles in a stylish way. I've always enjoyed working with graphics, but it's never too clever to re-invent …
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

821 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question