query

[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 you.

siri

[kubben]

This is the wrong forum. This should be posted on the sql forum. Still the answer should be something like: select sno, productid, brandid from table where sno = (select max(sno) from table) Hope that helps. Ben