If you’re a SQL expert, plz plz comment so I can message you about a query I need help with. Thank you!

like
Posting as :
works at
You are currently posting as works at

No, you don't need a right outer join. Probably never.

funny

I’ll try

Lmk

Related Posts

How do I go about executing international arbitrage trades without setting off red flags? Have any of you done it before?

like

Hi fishes!!

Looking for job change in HR( recruitment- generalist- 1year exp)

I would appreciate any referral!

like

Been in an all encompassing customer service role in a non-profit for 5+ years and wanted to knows how and if it’s possible to switch to a customer success role? Is that a stretch or are all the skills transferable?

like

I live in a house with roommates and one roommate wakes me up every time she leaves for work simply because her door is loud. Any idea what home improvement solutions would make sense to block the noise?

I put some cushioned draft stoppers under the doors and that's helped a bit, but I'm looking for more. I'm not sure what exactly works best for low frequencies like doors closing. Some $12/12 pack foam acoustic panels look promising, as does a $100 sound damper curtain...

like

Hi fishes,

May I know how much will be the in hand salary after all deductions?
Also I can't see any variable pay component in it and does BoB come under fixed salary?

Post Photo
like

Hey Fishes,
I am suppose to join BNY Pune on grade I very soon. Wanted to check on how is the bank doing in the recession time. Any chances of layoffs predicted? Is the bank suffering any loss?

like

Rate my offer for a business valuations/litigation & legal disputes support associate role at a boutique firm in Toronto:

- $90k + ~7.5% annual performance bonus
- $5k in clawback reimbursement
- will pay all professional fees throughout term of employment (CPA & CBV)

My background:
- SA1 in assurance
- Master of Accounting
- passed CFE, qualify in about half a year
- enrolled in CBV program of studies
- 24 yrs old

How have you dealt with/recovered from burnout and feelings of numbness while working as a therapist?

likeuplifting

Feeling so overwhelmed. Trying to find the balance between an ambitious career and raising a toddler. Feel like I am failing on both fronts. Just can't seem to wrap my head around... (Cont)

like

Hi I am looking for possible opportunities as an Occupational Therapist to move towards the non-clinical side of healthcare in the Denver area.

like

I just got a drug charge (weed) that is a misdemeanor and i have a clearance. It could possibly be expunged, but maybe not. Should i report this to my FSO officer? Will i lose my job? 1st offense ever

like

Men: Any recommendations for cool T shirts ? Bored of solid or plain T shirts, looking to see any brands with a little more variety ? Not looking for crazy designs simple but better than solids.

like

I am a new jr. credit analyst at a commercial banking institution. I've been there 2.5 months so far, and feel like I'm doing very well, as does my boss. I do not have a finance degree, but a business admin degree instead. I didn't plan on banking, but I left my prior industry and got this job through someone I know knowing someone at the bank. I'm 24 years old and my business degree is from a very solid business school. What should I be getting paid (salaried)? Curious if I'm being underpaid.

like

Any other ladies have an end goal of becoming an entrepreneur? I'm looking for some inspiration whether it be in the form of books, events, whatever!

like

How do you guys recover from a flu/virus? Doctor said take Tylenol and water. Not helping

As part of relocation,LTI is giving Rs. 4350 per person from base location (my previous company ofc location let’s say it location A) to ofc location (LTI Ofc let’s say it location B).
Since I’m in my hometown(let’s say it location C).
So can I book train from A to B & cancel it later and submit the booked bill to get it reimbursed as I have to anyway travel from C to B but LTI only reimburse if I travel from A to B?
Kind of fraud but is it allowed or bills are scrutinised and I may be at risk?

funny

What is the process of virtual onboarding in Larsen & Toubro Infotech, and what they do on first day of joining?

like

Do sales engineers need to create their own slide decks for demos or can they walk through the software itself? Thanks!

like

We gonna see 47K again?

like

Hiya, brand strategist here who wants to learn more about the media side of things. Any books, pubs, courses you can recommend? Thanks!

like

Additional Posts in Software Engineering

Where can I join? Any suggestions or reviews?
4YOE - JAVA SOFTWARE ENGINEER
Here are the offers:
EPAM Anywhere - 18 LPA + 0.6 LPA (JB)
HCL Technologies - 20 LPA (2lpa variable)
Capco (WIPRO CHILD COMPANY) - 20.5 LPA + 2 LPA (JB)
Infosys - in process
STL - Sterlite Technologies Limited - in process
Mindtree - in process
Capgemini - in process
Tech Mahindra - in process

Please give the reviews about this asap. Thanks in advance.

like

The company I work for (a data analytics consulting firm) was recently acquired by a larger firm. Based on sites like Glassdoor, their SWE are making almost double what I make. There is a lot of discussion about retention of employees, so should I expect my compensation to be adjusted? Should I mention this in my upcoming performance review if feedback is positive?

like

Why are there so many “full-stack” engineers that can’t write basic HTML and CSS?

likefunny

How difficult is it to get a job in a language you don't have experience in? I have 7 years of experience in PHP and the job market doesn't seem to have a lot of openings. Lots of Python and Java though. I've applied to a number of these roles and haven't even gotten a phone screen.

Is it me? Or the market?

How can I prepare and present myself for a job in a new tech stack?

like

I can't find a really interesting bowl here.

Does anyone know or be interested in an open-source bowl, for example?

Please suggest me good bowls 🙏

like

How do you all deal with the guilt of leaving a comany/ team? I have been working at Microsoft for 1 year now, and seriously considering moving. I find the code base to be very legacy and I mostly work on obscure bugs that I spend so much time on, mostly due to navigating this large code base and not having much docs to refer to. Hence I find the job slightly unsatisfying, and that I could learn more elsewhere. However, I love the wlb, the team and company culture. The guilt stops my applying.

like

I'm a SWE from Italy. Love my country but salary and taxes here are outrageous. Got 2yrs experience in fullstack and data science, 2masters, a peer reviewed paper and outperform all my peers for 24k€ a year.
I'm thinkin about landing a remote SWE job (leetcoding and building a portfolio this summer).
Have you got some advice? Is it possible to work for US remotely without visa? What other countries pay well? Is it possible to land a 100k$+ with this kind of experience and working from Italy?

like

Hi, I have an upcoming interview with transferwise uk for software engineer position. Its going to be system design round along with some competency based questions.
Can someone who has interviewed with them before give me pointers on what to study for design and competency based questions please. 
current TC - 75k GBP

like

Jr PjM/BA 4 YOE in Tech Implementation Consulting. Beginner skills in Python, JS, HTML, CSS, AWS, SailPoint. Moderate in Azure, Okta. Have PMP, Certified Scrum Master, M.Sc., BBA. Want useful skills, but must focus energy and time. Recent projects and team just not filling my cup. Cloud Architecture, DevOps, InfoSec, IAM all seem interesting and highly rewarding. Taking CompTia N+ soon, and realizing its low demand. What certs & projects should I do to land a technical role within 1 yr?

Hi All, I recently interviewed at Amazon and Google for software engineer and passed both interviews. I have an offer on the table from Amazon but with Google I am officially in team matching and my recruiter tells me that the queue is pretty backed up now and it can take a long time. My question is should I take the Amazon offer now or decline Amazon and hold out for Google? I have heard that Google has better wlb/benefits. But I'm scared to decline Amazon without a guaranteed job offer.

like

Should I specialize in Blockchain or AI? I’m a freshman in a CS degree and I can’t decide. My main argument to choose blockchain is the easy entry with little experience and high salary, I plan on growing my skills during the bear market and get a job once the market recovers. Regarding AI, I find this field fascinating but I feel like it requires a lot of experience, degrees and diplomas.

like

I was today years old when I discovered that Shift + Tab is the anti Tab or not sure what to even call it 🫣

likefunny

Hey guys, I just recently graduated with my bachelors degree and am working full time as a software engineer. I want to continue my education and in a few years apply to one of the bigger tech companies. Not necessarily a FAANG, but I would like to be prepared enough that I could take a job at a FAANG company at a mid senior level. What would you guys suggest doing to further my education? Are there classes or certifications that would be helpful? I hear a lot of people talking leet code?

like

Hi, I changed my job like 3 months ago, it was supposed to be a lead front end engineer position, but after and awful onboarding I’m just a regular dev in a project that is not yet live but requires a lot of refactor. It was supposed to be a project to get familiar with the company but at this point I don’t know what to do. Give them some time, talk with them about my situation or just look for another job. What do you think about it?

like

I have a technical interview with Google Software Engineering team. Anyone know what kind of questions they will ask? What are the best Google offices in the US or Canafa? are they flexible with remote work?

like

I filed an ethics complaint in early June, and after going up the chain and calling out nothing was done on it, and I was being gaslighted/my personal life being used to show I am the problem in early October, I met with the execs in Ethics. The initial meeting, they gaslighted me, and then tone was better in the second meeting. Now 2-3 weeks later, General Counsel wants to see me. What should I do? Should I be worried? I have sought counsel outside of the company. This is huge fintech company.

like

Hello!
Does someone know how it is to work nowadays at LiveTiles? I have seen a lot of negative comments about management and the CEO, but I wonder how does it affect the engineering teams.

like

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
That was just a preview…
Sign Up to see all discussions
  • Discover what it’s like to work at companies from real professionals
  • Get candid advice from people in your field in a safe space
  • Chat and network with other professionals in your field
Sign up in seconds to unlock all discussions on Fishbowl.

Already a user?
Login here

Share

Embed this post

Copy and paste embed code on your site

Preview

Download the
Fishbowl app

See what’s happening in your industry
from the palm of your hand.

A phone with Fishbowl app

Scan your QR code to download
Fishbowl app on your mobile

Download app

Sign up for free to view this conversation on Fishbowl

By continuing you agree to Terms of Use and Privacy Policy

Already have an account? Log in

Sign up for free to continue using Fishbowl

By continuing you agree to Terms of Use(New) and Privacy Policy(New)
Messaging rates may apply

Already have an account? Log in

For account settings, visit Fishbowl on Desktop Browser or

General

Legal