Your browser does not seem to support JavaScript. As a result, your viewing experience will be diminished, and you have been placed in read-only mode.

Please download a browser that supports JavaScript, or enable it if it's disabled (i.e. NoScript).

Query

4 Posts 2 Posters 0 Views 1 Watching

S Offline
S Offline
sirisha guttikonda

wrote on last edited by

#1

hi all i need help to write a query I have a table with the coloumns SNo ,ProductId and brandId SNo is given as identity true now want to retrive a ProductID whose SNo is maximum value thank u.

siri
S 1 Reply Last reply

0
S sirisha guttikonda

hi all i need help to write a query I have a table with the coloumns SNo ,ProductId and brandId SNo is given as identity true now want to retrive a ProductID whose SNo is maximum value thank u.

siri
S Offline
S Offline
Sandeep Kumar

wrote on last edited by

#2

Hi....here is the query........ SELECT ProductID from tablename where SNo = (SELECT MAX(SNO) from tablename)

Regards, Sandeep Kumar.V
S 1 Reply Last reply

0
S Sandeep Kumar

Hi....here is the query........ SELECT ProductID from tablename where SNo = (SELECT MAX(SNO) from tablename)

Regards, Sandeep Kumar.V
S Offline
S Offline
sirisha guttikonda

wrote on last edited by

#3

Thanks sundeep...

siri
S 1 Reply Last reply

0
S sirisha guttikonda

Thanks sundeep...

siri
S Offline
S Offline
Sandeep Kumar

wrote on last edited by

#4

Welcome........:)

Regards, Sandeep Kumar.V
1 Reply Last reply

0

Log in to reply