Tech Diary

August 14, 2019

serial rank in select statement

sel
a,
b,
rank() over(order by c)
from table1

Posted by DV at August 14, 2019
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Labels: SQL, Tech, Teradata

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

Total Pageviews

24,623

Search This Blog

Labels

  • AWS
  • Bitbucket
  • Data Science
  • Finance
  • Git
  • Graph data
  • ionic
  • Java
  • JBoss
  • Linux
  • MySQL
  • R
  • Recursive
  • Regular Expression
  • S3
  • Scheduling
  • SQL
  • Tech
  • Technical Analysis
  • Teradata
  • Unix
  • Web

About Me

DV
View my complete profile

Blog Archive

  • ►  2022 (1)
    • ►  March (1)
  • ►  2021 (1)
    • ►  February (1)
  • ►  2020 (2)
    • ►  March (1)
    • ►  February (1)
  • ▼  2019 (29)
    • ▼  August (1)
      • serial rank in select statement
    • ►  July (1)
    • ►  June (1)
    • ►  April (5)
    • ►  March (20)
    • ►  January (1)
  • ►  2018 (84)
    • ►  December (56)
    • ►  November (27)
    • ►  June (1)
  • ►  2017 (18)
    • ►  November (1)
    • ►  September (1)
    • ►  August (1)
    • ►  July (3)
    • ►  May (1)
    • ►  February (9)
    • ►  January (2)
  • ►  2016 (15)
    • ►  October (2)
    • ►  September (4)
    • ►  July (6)
    • ►  June (2)
    • ►  May (1)
  • ►  2015 (3)
    • ►  July (2)
    • ►  June (1)
  • ►  2014 (20)
    • ►  September (3)
    • ►  August (8)
    • ►  July (5)
    • ►  May (3)
    • ►  April (1)

Popular Posts

  • Teradata SQL Syntax error: All expressions in a derived table must have an explicit name.
    The below statement threw this error: SQL Syntax error: All expressions in a derived table must have an explicit name. select v1.* from di...
  • Teradata SQL INDEX function
    This is equivalent to ANSI SQL POSITION function. Example: SELECT INDEX('Teradata', 'd');    Returns 5   SELECT INDEX(...
  • Basis Points
    1 basis point = 1/100 of a percentage. Used mainly in Finance like changes in interest rate. Example: "The Federal Open Market Commi...
  • Different types of VPN
    Different types of VPNs: 1. Site-to-Site VPN, 2. Dynamic VPN (DMVPN), 3. Client VPN, 4. SSLVPN is explained clearly in this blog. http:...
  • Treasury Stock
    When a comany buys back its own shares and doesn’t retire them, those shares are called Treasury Stock
  • Teradata sql - retrieve top and bottom 50 percentage of the records
    Top 50% ---------- select top 50 percent  * from table1 order by id asc Bottom 50% --------------- select top 50 percent  * from ta...
  • Teradata SQL Regular Expression to compare date format
    Verify if date is in format dd-MMM-yyyy select  regexp_similar(a_date,'^(([0-9])|([0-2][0-9])|([3][0-1]))\-(JAN|FEB|MAR|APR|MAY|JUN|J...
  • (no title)
    Some Teradata Warehouse Appliance 2700 facts Ref: http://www.teradata.com/brochures/teradata-data-warehouse-appliance-2700/
  • Spider - SPDR
    Stands for Standard & Poor’s Depository Receipt. It is a S&P 500 index based ETF maintained by State Street Global Advisors. Each sh...
  • Teradata: Rename table
    rename table table1 to table2
Simple theme. Powered by Blogger.