To get the 3rd most expensive item :
Select b.price , b.Id , b.name
from Item b, Item b
where
b.price <= a.price
group by (b.price)
having count(b.price) = 3
Type: Posts; User: siddhartha_sanyal; Keyword(s):
To get the 3rd most expensive item :
Select b.price , b.Id , b.name
from Item b, Item b
where
b.price <= a.price
group by (b.price)
having count(b.price) = 3
ABS(argument) will work.
A trigger is a block of statements that includes a set of SQL statements. Statements in a trigger are activated or executed in response to data modification operations. A trigger defined on a table...
Thanks Dude for such a warm welcome.
Hi Friends.
I'm a new member.