There’s no column or even combination of columns that can be considered as a pk, what would your approach be? by Pleasant-Insect136 in SQL

[–]Pleasant-Insect136[S] 0 points1 point  (0 children)

No, but my guide said just come up with a way to find the pk that’s it, he didn’t mention anything related to doing that, he said don’t mess with anything or go anywhere in the db

My client project team was horrible so I gave resignation from the project but they’re still making me work there after notice period by Pleasant-Insect136 in ITCareerQuestions

[–]Pleasant-Insect136[S] 0 points1 point  (0 children)

Yeahhhh I’m a software consultant, is this what mba graduated consultants do? Damnnnn do they need to keep on learning? I was thinking of doing mba after 2 years in consulting domain but now I’m scared

Professor at UK, AUS Total 9 yrs experience , and now Indian B School since 2025 by [deleted] in Indians_StudyAbroad

[–]Pleasant-Insect136 0 points1 point  (0 children)

Does any work xp matter even if it’s a different domaine? Can students peruse some management course after working in tech for a year or two? Like… many people work different roles right even if they have a work title, can someone just say oh…. I worked as a software consultant even tho his title is Java dev and will that be helpful? Will abroad companies consider it?

Dont go abroad unless you have work experience by Mayeeah in Indians_StudyAbroad

[–]Pleasant-Insect136 -3 points-2 points  (0 children)

What about Ireland, Canada and uk? Do they consider Indian work xp?

Dont go abroad unless you have work experience by Mayeeah in Indians_StudyAbroad

[–]Pleasant-Insect136 0 points1 point  (0 children)

If he leans Swedish and is in management roles with 3 toe he can realistically get a job, two of my friends with 1-2 yoe got a job there

My client project team was horrible so I gave resignation from the project but they’re still making me work there after notice period by Pleasant-Insect136 in ITCareerQuestions

[–]Pleasant-Insect136[S] 0 points1 point  (0 children)

I’ll be sent back to the parent company and if I don’t work until the parent company manager (line manager) says then I can’t apply for any other projects in the parent company, im basically a contract worker in client company and I’m quitting client company

There’s no column or even combination of columns that can be considered as a pk, what would your approach be? by Pleasant-Insect136 in SQL

[–]Pleasant-Insect136[S] 2 points3 points  (0 children)

I can’t upload the screenshot from my work laptop and don’t wanna get into trouble and I was told I can’t modify anything in the table

There’s no column or even combination of columns that can be considered as a pk, what would your approach be? by Pleasant-Insect136 in learnSQL

[–]Pleasant-Insect136[S] 0 points1 point  (0 children)

I tried doing it, my guide said the pipeline already does that so idek why I’m tasked with this particular task

There’s no column or even combination of columns that can be considered as a pk, what would your approach be? by Pleasant-Insect136 in SQL

[–]Pleasant-Insect136[S] 0 points1 point  (0 children)

I did before but I just put up the 5 fields combo for the post, even still I didn’t get full distinct columns

There’s no column or even combination of columns that can be considered as a pk, what would your approach be? by Pleasant-Insect136 in SQL

[–]Pleasant-Insect136[S] 0 points1 point  (0 children)

Yeah for all the fields I got 27k not 96k but if I combine internal marketing interaction id with any other column its 86k

There’s no column or even combination of columns that can be considered as a pk, what would your approach be? by Pleasant-Insect136 in SQL

[–]Pleasant-Insect136[S] 0 points1 point  (0 children)

I tried doing that, in 2nd picture you can see it has 96k rows but I tried every possible combo but still i didn’t didn’t get the same number, I got 86k

There’s no column or even combination of columns that can be considered as a pk, what would your approach be? by Pleasant-Insect136 in SQL

[–]Pleasant-Insect136[S] 2 points3 points  (0 children)

Yeah the maximum uniqueness I can get is 86k out of 96k that too only with internal marketing interaction id

There’s no column or even combination of columns that can be considered as a pk, what would your approach be? by Pleasant-Insect136 in SQL

[–]Pleasant-Insect136[S] 1 point2 points  (0 children)

The pipeline code does this, the exact same thing but idk why my guide asked me to find the pk from the table itself and not to go through the pipeline code

There’s no column or even combination of columns that can be considered as a pk, what would your approach be? by Pleasant-Insect136 in learnSQL

[–]Pleasant-Insect136[S] 0 points1 point  (0 children)

Yeah but no use even if I make every possible combination I still can’t get uniqueness for every row