Member since
10-06-2016
2
Posts
1
Kudos Received
0
Solutions
10-07-2016
05:26 AM
Hi Vaibhav, Which version of hive you are working with? Please check below link https://cwiki.apache.org/confluence/display/Hive/Common+Table+Expression
... View more
10-06-2016
10:47 AM
1 Kudo
please use below query with t as ( select row_number() over (order by Codes) as RowNum, ID,Codes ) select * from t where RowNum=3;
... View more