Answers

query to get maximum amount

Sukesh Marla

14y7k

Consider a table having a column say amount, write a query to get maximum amount without using order By and max keyword.

9 Answers

maximum amount means simple you use MAX()
select MAX(Amount) from tblaccount.

Rajeev Kumar3y

Select Max(A.Amount) from tbl_Amonttable A

Mohd Sohaib Jummal7y

HOW TO WRITE SQL QUERY 2ND HIGHEST SALARY USING SELF JOIN

Suresh Bharti11y

For SQL SERVER INTERVIEW QUERIES QUESTION FOLLOW THE BELOW LINK MORE THAN 100 MS SQL SERVER INTERVIEW QUERIES WITH EXAMPLE http://www.interviewquestionspdf.com/2014/07/sql-queries-interview-questions-answers.html

Vikas Ahlawat12y

SELECT E1.SALARY FROM salary E1 WHERE 1= (SELECT COUNT(distinct (E2.salary)) FROM salary E2 WHERE E2.salary >=E1.salary)

Neeraj Kumar13y

SELECT E1.SALARY FROM Employee E1 WHERE 2-1 = (SELECT COUNT(distinct (E2.salary)) FROM Employee E2 WHERE E2.salary < E1.salary)

Karthikeyan M14y

SELECT E1.SALARY FROM Employee E1 WHERE 2-1 = (SELECT COUNT(distinct (E2.salary)) FROM Employee E2 WHERE E2.salary < E1.salary)

Karthikeyan M14y

SELECT E1.SALARY FROM Employee E1 WHERE 1-1 = (SELECT COUNT(distinct (E2.salary)) FROM Employee E2 WHERE E2.salary > E1.salary)

Sandeep Singh Shekhawat14y

Declare @MaxValue int
Select @MaxValue=(case when @MaxValue>Amount then @MaxValue else Amount end) From T1
Select @Maxvalue

Declare @MaxValue int
Select @MaxValue=Amount From T1 Group by Amount
Select @MaxValue

SELECT 
T11.Id,
T11.Amount as MaxAmount
FROM T1 AS T11 left outER JOIN
T1 AS T12 ON T11.Amount < T12.Amount 
GROUP BY T11.Amount, T11.Id
having COUNT(T12.Amount)=0

Sukesh Marla14y