Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
How can I write query to generate info and write to new table?
Hi all, I have this information employee(status Integer not null, pay_rate numeric Not null, payment_id integer not Null, checkIn timestamp without time zone Not null, checkOut timestamp without time zone Not null, employee_id integer Not null); I want... -
How can I get the max() of this entry with coressponding name?
Perfect, PHV. Thank you guys! -
How can I get the max() of this entry with coressponding name?
Thanks nigelrivett. /// select top 1 Product_id, volume /// does not work. I use Postgre Sql (7.xx). Do you know something similar to "top 1" for postgre sql? Thanks. -
How can I get the max() of this entry with coressponding name?
Hi all, I have this table sales ( product_id Serial Not Null, price Numeric Not Null, product_code Char(3) Not Null); sales (product_id,price, product); I want to write a query that return the products that sold with the highest volume, for example: product_id _|_ Volume 1...
