Community Sites
Create your own community website and start earning today !
It's Free !

Forum Resources Mentors Projects Entrance Exams Question Papers Colleges Courses Universities Schools Make Money

Communities Members Bookmarks Polls Fresher Jobs Funny Pictures MCA Projects New Member FAQ

My Profile

AdSense Revenue

Active Members
Today

kavi (36)
Sandy (11)
Mala (10)

Last 7 Days

Ramesh Gupta (2362)
Satyanarayana ... (1632)
sunil (1169)

more...

Awards & Gifts

Online Exams

Fresher Jobs

Our fresher job section is exclusively for fresh graduates! Find jobs for freshers in major Indian cities including Bangalore, Chennai, Hyderabad, Pune or Kochi

Resources

Find educational articles, blogs, discussion threads and other resources.

Colleges

Find details about any college in India or search for courses.

How to find second maximum value from a table?

Posted Date: 11 Mar 2008 Resource Type: Articles/Knowledge Sharing Category: Placement Papers

Posted By: ramya Member Level: Gold
Rating:

Points: 1

select * from emp A
where N=(select * from emp B
where A.sal>B.sal)

here 'N' is number
If u want 2nd high sal , put n=2
if u want 10th high sal , putn=10.
excuse me if u find any error's

Responses

No responses found. Be the first to respond and make money from revenue sharing program.

Feedbacks

Popular Tags

What are tags ?

Search Tags

(No tags found.)

Post Feedback

This is a strictly moderated forum. Only approved messages will appear in the site. Please use 'Spell Check' in Google toolbar before you submit.
You must Sign In to post a response.

	Next Resource: Winrunner Q and A
	Previous Resource: oracle tutorial 1
	Return to Discussion Resource Index
	Post New Resource
	Category: Placement Papers

Post resources and earn money!

Related Resources

Watch TV Channels

Watch Asianet TV online

Kairali TV in Internet

Surya TV online

Amritha TV Channel