Req code for Max value of table

Posted Date: 06 Nov 2009 Posted By: Narasimha Member Level: Bronze Points: 1 Responses: 6

Hi All,

I am using SQL server, i want sample source code for finding max value in the table,

rgds
Rao

Responses

Author: Mohan 06 Nov 2009 Member Level: Diamond Rating: Points: 2

try this

select max(Qty) from tablename

Regards

Mohan Kumar.D

Author: krishnavenikaladi 06 Nov 2009 Member Level: Gold Rating: Points: 2

hi,
select MAX(columnname) from tablename;

Author: Anil Kumar Pandey 06 Nov 2009 Member Level: Diamond Rating: Points: 2

you can use this query for the same


  select max(ColName) from tablename

Thanks & Regards
Anil Kumar Pandey

Author: Deepika Haridas 06 Nov 2009 Member Level: Diamond Rating: Points: 2

Hello,

You can write


SELECT max(field) FROM tablename;

Thanks & Regards,
Deepika
Editor

If U want to shine like a SUN..First U have to burn like the SUN!!
Need a Guide? Join my mentor program..

Author: Hari 06 Nov 2009 Member Level: Gold Rating: Points: 2

select max(Col) from tablename

Author: Kirtan 08 Nov 2009 Member Level: Silver Rating: Points: 2

select max(<columnname>) from tablename

Kirtan Patel
-----------------------------------------------------
Master Of Computer Application(Sem-1)
Bachelore of Computer Application

Post Reply

You must Sign In to post a response.

	Next : validation expressions for date, characters,
	Previous : Diff B/w the Debug and Release folder
	Return to Discussion Forum
	Post New Message
	Category: .NET

Related Messages

dotNet Slackers

About Us Contact Us Privacy Policy Terms Of Use