Ask a Question
Ask Question Login
Corporate Training
  1. Community
  2. Hellen Cargill

Hellen Cargill

Community Learner
Share
4Questions
3Answers
5.2KViews on questions

What are the differences between order by 1 and order by column name?

In the context of SQL the “SQL order by 1” is used to sort the query results based on the first column in the SELECT clause. On the other hand, the ORDER BY clause is used in arranging the retrieved data in both ascending and descending order. The basis used by the order is specified columns or the positional indices…

SQL Server

Answered Dec 14, 2023 · 868 Views Read answer →

How to concatenate or delete variables?

In python, you can concatenate two variables with each other and if both variables are the same type then its easy to concatenate but if one is numeric and the other is a string then before concatenating you must convert numeric variable as a string. Please see below example for better understanding: #Declaring a…

Data Science

Answered Jan 12, 2020 · 1.5K Views Read answer →

More members from the Data Science community

Learners asking and answering questions on the same topics — follow their questions and join in.

Latest Data Science Blogs

Guides, tips and career advice on Data Science from JanBask experts.

Learn & Explore

Free tutorials and interview questions from industry experts — learn the skill, then get ready to prove it.