By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,590 Members | 2,191 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,590 IT Pros & Developers. It's quick & easy.

DB2 Select Max Statement

P: 1
hi everyone ,


i am trying to bring a max sequence number value from a DB2 Table , can anyone please let me know if my SQL is right

i have two columns here in the table
seq_value
seq_name

SELECT MAX(SEQ_VALUE) as Max from schema.table name WHERE SEQ_NAME = TBC_GC_HEADER;

please suggest

thanks
Jan 26 '07 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.