Suppose A Customer Table Is Having Different Columns Like Customer No

1.	Suppose A Customer Table Is Having Different Columns Like Customer No, Payments. What Will Be The Query To Select Top Three Max Payments?
Answer» SELECT customer_no, payments from customer C1 WHERE 3&LT;=(SELECT COUNT() from customer C2 WHERE C1.payment <= C2.payment) SELECT customer_no, payments from customer C1 WHERE 3<=(SELECT COUNT() from customer C2 WHERE C1.payment <= C2.payment)

Suppose A Customer Table Is Having Different Columns Like Customer No, Payments. What Will Be The Query To Select Top Three Max Payments?

Answer»

SELECT customer_no, payments from customer C1
WHERE 3&LT;=(SELECT COUNT(*) from customer C2
WHERE C1.payment <= C2.payment)

SELECT customer_no, payments from customer C1
WHERE 3<=(SELECT COUNT(*) from customer C2
WHERE C1.payment <= C2.payment)