Related Posts
Any one know how ip lit is at MoFo Los Angeles?
Tech Mahindra Hey guys, I attempted Hackathon by tech Mahindra (for jr java developer 1-3 yr exp). After 3 days I received a call from hr confirming that I have been shortlisted and took hr round on that call. Later I received a document verification mail asking for all essential docs which are required for joining, but didn't received any offer letter yet. When I cross checked mail address with my friend in tech Mahindra, he confirmed that such hr exists with same e-mail id. Is it normal in tech Mahindra?
Additional Posts in Data & Analytics Consultants
New to Fishbowl?
unlock all discussions on Fishbowl.
Let me stackoverflow that for you
Pretty new to SQL, looked through stack overflow but I keep getting the same queries which keep coming up blank for me
Table name column does not have schema. Your where clause should be:
Table_name = ‘mytablename’
Schema is in a separate column
“And” instead of another “where”
Add table name to your select and remove the filter. Add the where statement back as a LIKE condition with wildcards to see if the filter is off. Not super familiar with postgres but could be a case issue or something
Conceptually your approach is right, you should have the following where conditions:
Where table_name = ‘mytablename’ and table_schema = ‘myschemaname’
Thank you so much! This is all new to me and I'm sure this is a basic query for you all! Appreciate your assistance!
try “select top 10 * “ in the first row - that will tell you if the error is in the first row