python (12.9k questions)

javascript (9.2k questions)

reactjs (4.7k questions)

java (4.2k questions)

java (4.2k questions)

c# (3.5k questions)

c# (3.5k questions)

html (3.3k questions)

Questions - netezza

How do I get rows with max values across two columns

I would like to know how to filter down a table by getting the max values from two columns. Here is a simplified input table. I want one row per person which has the max(year) and max(version) Nam...
test-img

Saif Ahmed

sql

aggregate-functions

greatest-n-per-group

netezza

Votes: 0

Answers: 1

Latest Answer

Performance aside, this generic SQL should do it: SELECT * FROM t WHERE NOT EXISTS ( -- select rows for that person-year-version -- where year is greater or (year is same and version is greate...
test-img

Salman A

Loading data to Netezza using nzload utility

I am trying to load data into Netezza database using "nzload" utility. The control file is as below and it works without any issues. Is there a way to provide multiple data files as the inpu...
test-img

Karthick88it

file-upload

netezza

bulk-load

Votes: 0

Answers: 2

Latest Answer

$ cat my_control_file datafile my_file1 {} datafile my_file2 {} datafile my_file3 {} datafile my_file4 {} # Below, I specify many of the options # on the command line itself ... s...
test-img

Mark F

substrr Comma Separated column value to rows in netezza

I have a table Sample with data stored like below Id | String -------------- 1 abc,def,ghi 2 jkl,mno,pqr I need the output like.. Id | processedrows -------------- 1 abc 1 def 1 ...
test-img

Danh Tran Quoc

sql-server

netezza

Votes: 0

Answers: 0

Posts

Questions

Blogs

Jobs