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

comparing two values in same but in different rows

P: 1
i have a table with following columns destination next hop and distance i have two rows with same destination number but different distances i want to use the next hop of the destination whose distance is the least
Mar 29 '13 #1
Share this Question
Share on Google+
1 Reply


10K+
P: 13,264
What have you tried? hint: The MIN function can give you the least value in a column.
Mar 29 '13 #2

Post your reply

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