• Post Reply Bookmark Topic Watch Topic
  • New Topic

About MAX() in MS-SQL 2000

 
Huang Chung-Yu
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I want select a data from a db
just like as "Select MAX(grade) from gradeFrom"..
now..I want to who the MAX(grade) in jLabel..
How should I do?
 
Julian Kennedy
Ranch Hand
Posts: 823
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Huang Chung-Yu,

Welcome to JavaRanch!

I'm not sure I understand your question. Are you looking for a way to get a list of the names of people (or a single person) who got the highest grade, so that you can display it in a Swing application?

If so, such a query might look like this:

It's a bit simpler if you have students and grades in the same table.

As for the JLabel, you're on your own!

Jules
 
Today you are you, that is turer than true. There is no one alive who is youer than you! - Seuss. Tiny ad:
the new thread boost feature: great for the advertiser and smooth for the coderanch user
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!