Find the second largest salary from emp table - AndreaVB Visual Basic and VB.NET source code discussion board

Previous Topic (connecting database witrh vb6)

AndreaVB Forum : Database : Find the second largest salary from emp table

Poster

Message

Chris_871
Level: Master

Registered: 30-11-2002
Posts: 106

Find the second largest salary from emp table

select max(sal) from emp where sal < (select max(sal) from emp)

10-01-2003 at 09:45 AM

vbgen
Level: Moderator

Registered: 10-10-2002
Posts: 876

Re: Find the second largest salary from emp table

hmmm!! free code! simple, but useful....

YUM! thanks, chris.

____________________________
Been busy trying to take a second degree <--it's not working out...

10-01-2003 at 06:12 PM

noycez
Level: VB Guru

Registered: 14-10-2002
Posts: 79

Re: Find the second largest salary from emp table

twooo000OOOOO thumbs up!!!

____________________________
Funny thought:

Practice makes perfect.....
But nobody's perfect......
so why practice?

11-01-2003 at 02:14 AM

p_malant
Level: Guest

more....

Good thinking Mr.Chris.Thanks for the free query.
I think there is one more solution for this question.
Can anyone send the second correct query?

11-01-2003 at 08:58 AM

AndreaVB Forum : Database : Find the second largest salary from emp table


	Surf To:



	AndreaVB Visual Basic and VB.NET source code resources - Copyright © 1999-2007 Andrea Tincani