SQL Trick | Custom Sorting #sqltips

preview_player
Показать описание
In this SQL Trick, we learn how to perform Custom Sorting in a SQL Query.

How to install SQL Server for practice?

Check out the complete list of SQL Query Interview Questions -

Must Do Data Analytics Certifications -

Google Data Analytics Professional Certificate

Google Advanced Data Analytics Professional Certificate

Best Data Science / Analytics / SQL courses
Learn SQL Basics for Data Science Specialization

Beginners to Python Programming

Data Science and Business Analytics with Python

IBM Data Science Professional Certificate

Data Science Fundamentals with Python and SQL Specialization

Python for Everybody Specialization

Google Data Analytics Professional Certificate

Coursera Plus - Data Science Career Skills

Please do not forget to like, subscribe and share.

For enrolling and enquiries, please contact us at
Рекомендации по теме
Комментарии
Автор

Can you make video on reading Excel in datastage having numeric values greater than 15 digit.

jk.
Автор

Why 1 ?, it will not sort other data as expected reason is output is 0, 1, 1, 1, 1 for order by. So, it would be random output with HR on top.

Try using order by case dept when
'HR' then 1 else 0 end, dept

userzzzabc