how to get first 5 records in sql oracle ||ORACLE

[@hoperight5280]

MsSQL : TOP 5 PostgreSQL : limit 5 Just in case

[@TheLearningLibrary244]

Thanks

[@myjio6914]

We can use fetch first 5 rows only also in oracle

[@TheLearningLibrary244]

Did anyone want detailed video on oracle installation

[@ashwinmali2137]

yes bro

[@TheLearningLibrary244]

@@ashwinmali2137 i have already made one video you can go to oracle database playlist in my channel

[@aqsa1072]

How to open left panel if we cross it by mistake

[@nomulanikhila4722]

in this software developer tool is free or having any charge please give me the reply.why because I'm little bit confused

[@TheLearningLibrary244]

This is a complete free software you can use it free of cost, just reply if you want a video on how to install it

[@swathig9346]

Which tool you are using for practicing?

[@TheLearningLibrary244]

Sql developer

[@TheLearningLibrary244]

If you want a video on how to install sql developer then coment back on this

[@nageswarinakka6302]

​@@TheLearningLibrary244yes i want

[@Saaral.V6]

How get all columns and top 5 rows from multiple tables

[@TheLearningLibrary244]

Should i make a separate video on that or do u want only query for that

[@Saaral.V6]

@@TheLearningLibrary244 i want that query only sir

[@TheLearningLibrary244]

@@Saaral.V6 you can use join to the data from different tables and then you can filter on that result to get top 5 records like below SELECT A.* FROM TABLE_1 A JOIN TABLE_2 B ON A.ID=B.ID WHERE ROWNUM < 6

[@TheLearningLibrary244]

Also add order by in the last of that query

[@TheLearningLibrary244]

@@Saaral.V6 did you got ur answer

[@rajasekharmedia8987]

I think It will not fetch first 5 records. It will fetch any 5 records from table .

[@TheLearningLibrary244]

We have to add order by asc to get first 5 records

[@nomulanikhila4722]

haa need a clear vedio.and how to create oracle account .oracle pag asking lot of personal details .if I'm submit all the details have any problem will arrise.plase give me the clear information.

[@TheLearningLibrary244]

Ok i will make a clear video on how to install oracle and upload it on this Saturday

[@mar_nine2057]

hello how to add the northwind database here

[@TheLearningLibrary244]

That is a different part, i will cover that in separate video

[@mar_nine2057]

yes please,badly needed. @@TheLearningLibrary244

[@sppavankumar-qv3ig]

WHAT IS THE VERSION OF THIS SQL

[@TheLearningLibrary244]

Its oracle 10g

[@sppavankumar-qv3ig]

Thank you BY any chances do you have google drive link to download@@TheLearningLibrary244

[@JishithK-j4s]

How to get complete raw

[@TheLearningLibrary244]

Didn't got your question

[@harshpanchal1243]

You can use limit too right?

[@TheLearningLibrary244]

Limit not supported in oracle

[@emirsansar]

@@TheLearningLibrary244 Does Oracle support FECTH FIRST x ROWS ONLY ?

[@nomulanikhila4722]

how to install SQL developer

[@TheLearningLibrary244]

I have already made one video on that you will find on oracle database playlist on my channel

[@TheLearningLibrary244]

Do you want me to make another video with clear picture

[@rambabumallula9762]

Remove music

[@anirbanpaul2639]

give me the database

[@TheLearningLibrary244]

I hvae already created one video on how to install oracle nad sql developer, if majority of members want me to make one detailed video on installation part i will make it