Oracle SQL Summary

xiaoxiao2021-03-06  100

How do I use the SQL statement to find the nth value in a column?

Select * from (select t. *, rank () over (Order by t.emp_no) Rank from Cus_Emp_basic T) c where c.rank = 2;

转载请注明原文地址:https://www.9cbs.com/read-104406.html

New Post(0)