ORDER multiple columns in SQL | Interview Question

This is a free video tutorial on writing order by clause in an oracle sql statement. This video tutorial demonstrated how we can use column name, column number, expression, function, null first, null last, asc and desc in an order by clause. Also the video tutorial explains the possible cause and the solution to ora-01791: not a selected expression oracle error
Subscribe to the channel : / @kishanmashru
Other Playlists:
Data Warehousing Concepts: • Data Warehousing Concepts
Python and Database: • Python | How to Instal...
SQL and PL/SQL Interview Questions: • SQL AND PL/SQL INTERVI...
SQL and PL/SQL concepts: • SQL and PLSQL
Content and video created by : Kishan Mashru

[@pujarihemanthkumar8101]

nice and clear explanation bro.

[@pankajkharade6936]

VERY GOOD EXPLANATION

[@raju34567-d]

Nice explanation

[@BishalBhowmik-dl8up]

Helpful Video

[@KishanMashru]

Glad it helped

[@mahendramungamuru9500]

What if I need to use an order by 1 for a few columns and to use the DESC order for a few columns how we can achieve this ?

[@crazycom9807]

Sir...in which version of Oracle this Nulls First and Nulls Last clause was introduced... please reply

[@parezdara7820]

Thanks ^_^

[@KishanMashru]

Welcome:) Hope you have liked the video and subscribed to our channel!!!

[@raju34567-d]

Bro speak louder. Voice is very low