How to write a Query to result in the Maximum Value being displayed as a result in SQL.?

Question

I am working on a SQL Query for a Table which contains 2 columns (Sno Number, Name Char). I need to get the name associated with the Maximum Sno as a Result.

The Query Which i use is

Select Sno, name from Temp where Sno=Max(Sno)
or
Select Max(Sno) as Sno, name from Temp.

Both are resukling in a Error....

Can u provide me a correct Query

Answer 1

SELECT MAX(Sno), Name FROM Temp GROUP BY Name



you have to include the GROUP BY clause when using any of the group functions (MAX(), MIN(), SUM(), etc) so the database knows how to relate the data in the other columns to determine the groups.

Answer 2

Select Sno, name from Temp

hanving Sno=Max(Sno)

Answer 3

Select top 1 [sno], [name] from [Temp] Order By [sno] desc

Answer 4

I don't know which DBMS you are using, but as far as pseudoSQL goes it should be something like:



SELECT Name Char from Temp ORDER BY Sno Number ASCEND LIMIT 1

Answer 5

answer:



SELECT Max(Sno), Name FROM Temp GROUP BY Name