Skip to main content

SQL Journey: Blog #14



I am now on what Alex the Analyst would call the advanced SQL queries. First off, the Common Table Expression or CTEs. Based on what I understood in the video, CTEs is similar to a function or class in Python which you can call out. It is just how I felt when I first encountered this expression.

Now, in this particular case, I tried to replicate what Alex is doing but also not copying the codes that he is using. I am just simply trying to understand what the expression that was used (which starts with WITH) and then observe how he used the said expression.

This was my code.


Now this code, resulted in the following error.

Msg 8156, Level 16, State 1, Line 84
The column 'EmployeeID' was specified multiple times for 'CTE_Employee'.

What does someone do in this day and age if we encounter something that bogs us down? We go to the internet especially to AI tools to aid us out. And, apparently, these tools will really come in handy. It stated that the error occurred because I am joining two tables which has the same "EmployeeID" column. Therefore, I must specify the columns which I need in the query. As a result,


Query Results:


Labels:

Comments

Post a Comment

Popular posts from this blog

Privacy Policy of ShinStats: descriptives calc

Privacy Policy Shin Nix built the ShinStats app as an Ad Supported app. This SERVICE is provided by Shin Nix at no cost and is intended for use as is. This page is used to inform visitors regarding my policies with the collection, use, and disclosure of Personal Information if anyone decided to use my Service. If you choose to use my Service, then you agree to the collection and use of information in relation to this policy. The Personal Information that I collect is used for providing and improving the Service. I will not use or share your information with anyone except as described in this Privacy Policy. The terms used in this Privacy Policy have the same meanings as in our Terms and Conditions, which are accessible at ShinStats unless otherwise defined in this Privacy Policy. Information Collection and Use For a better experience, while using our Service, I may require you to provide us with certain personally identifiable information. The information that I request will be retaine...
Post a Comment
Read more

Gears Update

It has been a while since my last post and many things have happened since then. For one, I decided to upgrade my laptop as I saw it fit for the direction I am moving towards particularly on data analytics. It's been almost 10 years since I bought "Julian", my first work laptop, and there were so many milestones that we shared together. I bought my first laptop during my second job in Taguig City. It served as an extension of myself as I work to earn for my family particularly in helping my siblings with their education as I am the eldest and breadwinner of the family. That laptop was able to create a joint personnel reporting system excel file which was used by the Philippine Army to be able to account their personnel on a national level during my stint as an Engineer / Researcher in the aforementioned organization. Julian was my laptop when I finished my Master's degree at the Ateneo de Davao University where I also created the Programmable Logic Controller Trainer ...
Post a Comment
Read more

Could this be my first...?

What's up Nixers! In today's blog, I want to discuss with you the things that I did these past two weeks. After my encounter with my colleague, Adonis, one of our discussions focused on the creation of an app that would help ease students' struggles. He was very passionate about an app for a civil engineering application involving beams under load. As our discussions went on, I do acknowledge that if that particular app would be realized, it would really benefit civil engineering students in a profound way. What I liked about the discussion was how the app was described. Like, if I put my self in the user's perspective, the user interface which he discussed would be "user-friendly" as he really understands the flow of how things are to be calculated. As we left and went each other's ways, I was inspired by an idea to create an app utilizing the python programs that I have already developed for statistics. Like, how useful would it be for students to guide ...
Post a Comment
Read more