How to show nth number of row only in oracle sql?

select t.test_long_name testname, 'Level Score '||ts.level_score as levelscore from wkapp.test_score ts inner join wkapp.certificate_test_score cts on (cts.test_score_id = ts.test_score_id) inner join [login to view URL] c on (c.certificate_id = cts.certificate_id) inner join wkapp.certificate_level cl on (cl.certificate_level_id = c.certificate_level_id) inner join wkapp.certificate_type ct on (ct.certificate_type_id = cl.certificate_type_id) inner join [login to view URL] t on (t.test_id = ts.test_id) inner join wkapp.agency_certificate_config acc on (acc.agency_id = c.agency_id) where c.certificate_id = :p_certificate_id and rownum = 2

Hi! I can help you with that, I am very good with all SQL queries, so it's not a big deal. n-th number in what sense? Do you know at least what columns, what column definitions (varchar, int, etc.) you have in the db? Let me know

Hi, I am Ravinder Kumar. I have done my post-graduation in MCA (Masters of Computer Application). I am an EXPERT WEB DEVELOPER AND GRAPHICS DESIGNER with a CREATIVE AND INNOVATIVE solutions. I specialize in Wordpress and squarespace. I have 5+ years of experience in the field. When you hire me, you see my skills and creativity. I can strongly assure you that I will be able to provide you according to your desire. Actually graphics is the soul of a website and permanent branding of a company. For the past few years I have developed couples of website. I specialize in meeting the needs of individuals. My focus is on developing practical business solutions, using a wide array of mature and proven plugins, components and 3rd party solutions to solve common small business website requirements. I'd be more than happy to offer you my services, so feel free to contact me for an interview. I look forward to hearing from you. They are following :- Graphics Designing : Adobe Photoshop, CoralDraw, Adobe Illistrator, Logo design, Web page design, Banner Design Web Designing : HTML, HTML5, CSS ,CSS3, Javascript Web Development : Core PHP CMS Development: Wordpress , Squarespace, Prestashop, Joomla, Weebly, Oscommerce, Opencart, Shopify Other : JQuery Thanks & Best Regards, Ravinder Kumar