How Can I Find The Maximum Value In A Data Base 'Row' Max() Used In Column Bt How Can I In Row?

Question

0.00/5 (No votes)

See more:

SQL-Server-2012

consider this is my table:-

id age SALARY
20 77 30000
10 8 50000
30 9 20000

have to find out without using column name because we don't know in which column contains the largest value
here I want know in first row which value is greatest ?
how can I find out the maximum value in particular row?

pls help meee

Posted 7-Jul-15 23:22pm

Manidas Payyoli

Updated 8-Jul-15 0:19am

v2

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2015-07-07T23:50:00

Solution 1

If you mean the "second greatest" value, then try:

SQL

WITH myTableWithRows AS (
    SELECT (ROW_NUMBER() OVER (ORDER BY myTable.Salary DESC)) as row,*
    FROM myTable)
SELECT * FROM myTableWithRows WHERE row = 2

Posted 7-Jul-15 23:50pm

OriginalGriff

Updated 7-Jul-15 23:51pm

v2

Comments

[no name] 8-Jul-15 6:08am

not second. Have to find out the greatest value. my table have 33 columns and 6000 rows.in fist row which is the maximum value? like dat

[no name] 8-Jul-15 6:10am

and we don't know which column consist that value so with out using column name we have to find out the maximum value in a particular row

OriginalGriff 8-Jul-15 6:26am

Without the column names? I can't think of any way you can do that: even a PIVOT needs the columns on which it is to work.

[no name] 8-Jul-15 6:43am

uff..that I don't know..i am fed up with these is there any way? I want to find out 1000 row's greatest value..hw can we select the column if we using column name?

OriginalGriff 8-Jul-15 7:13am

You can find out the max value in a row, if you use the column names:
http://stackoverflow.com/questions/71022/sql-max-of-multiple-columns
Presents several ways to do it.

[no name] 9-Jul-15 1:53am

vote of thanks (Y)

OriginalGriff 9-Jul-15 4:00am

You're welcome!