0 - 3 of 3 tags for analytic functions
Find Second Highest Salary - SQL

Hello Experts
New year greetings. I need another help. Creating a seperate post for that.

EMP

--------

ID NAME SAL DEPT

1 SAM 50 D1

2 TOM 50 D1

3 RAM 40 D1

4 PAM 30 D1

5 JAM 30 D1

6 MAM 40 D2

 

 

By Santanu84, 31 Dec 2014 | Tagged: sql analytic functions row numbering | 7 comments
Regular Expression On Teradata 14.0

Hi All,

By SD2012, 18 Feb 2014 | Tagged: Regular Expression sql teradata 14 Advanced analytic functions | 17 comments
Loading analytic function to a database other than beehive.

Hello:
When I log on to act from a database other than beehive as db_superuser I receive an error:
"Unable to open input file: install.sh"
I've already installed these once in beehive, but I want to be able to access them from another database.

By toadrw, 19 Oct 2013 | Tagged: analytic functions loading | 2 comments