This example shows how to select the nth value from the row in the table.

Content

• Software Environment
• Oracle SCOTT user
• Select the nth value from the table
• Select the nth small value from the table

 

Software Environment

• Windows Server 2008 R2
• Oracle 11g Release 1 (11.1)

 

Oracle SCOTT user

This article uses SCOTT's EMP table. The content is as follows:

     
      
       
        
         
          
           
            
             
              
               
                
                 
                  
                   
                    
                     
                      
                       
                        
                         
                          
                           
                            
                             
                              
                           
 
Select the nth value from the table
  
                           
      
                                
                                 
                                  
                                   
                                    
                                     
                                      
                                       
                                        
                                         
                                          
                                           
                                            
                                             
                                              
                                               
                                                
                                                 
                                                  
                                                   
                                                    
                                                     
                                                      
                                                       
                                                        
                                                         
                                                      
 
Select the nth small value from the table