GameTZ

Sign OnNon-Mobile

Who knows SQL??? Need help
18-Jan-23 10:26pm
#1
HybridCRoW
GameTZ Subscriber Triple Gold Good Trader Global Trader - willing to trade internationally Has Written 2 Reviews

Primarily in the PostgreSQL format.

I'm learning SQL and the tutorials I've been given do not make sense or explain how I can do a specific query. It keeps giving me errors... once it was giving me parse errors and I tried to look them up for better understanding and was not getting anything... then I got another error that wasn't a parse when I changed things around and still cannot get the explanation behind the error.

Anyone able to help would be greatly appreciated.
18-Jan-23 10:29pm
#2
MrBean
GameTZ Gold Subscriber 400 Trade Quintuple Gold Good Trader Gold Global Trader (7) Has Written 1 Review

I've worked in SQL Server for most of my career
Lots of similarities, what's the error/query?
18-Jan-23 11:08pm
#3
HybridCRoW
GameTZ Subscriber Triple Gold Good Trader Global Trader - willing to trade internationally Has Written 2 Reviews

Apparently I missed one bit of information in my search for help and I think I got it fixed... Issue is, the tutorials I was given didn't explain the code I used and I need to explain it to the technical interviewer what I learned and not say "I used Google."

I'll PM you the rest.
19-Jan-23 11:01am
#4
RVM
GameTZ Subscriber Quadruple Gold Good Trader

I know the basics.

19-Jan-23 11:54am
#5
HybridCRoW
GameTZ Subscriber Triple Gold Good Trader Global Trader - willing to trade internationally Has Written 2 Reviews

That's pretty much where I am at... just the basics, but I got the issue figured out.
19-Jan-23 12:44pm
#6
Archer
GameTZ Subscriber 500 Trade Quintuple Gold Good Trader Has Written 1 Review

People still use PostgreSQL?
19-Jan-23 1:02pm
#7
RVM
GameTZ Subscriber Quadruple Gold Good Trader

100% lol.

19-Jan-23 4:15pm
#8
HybridCRoW
GameTZ Subscriber Triple Gold Good Trader Global Trader - willing to trade internationally Has Written 2 Reviews

The assessments are based on "entry level/beginner" stuff... being able to read the information and using it correctly. First was HTML, second was SQL or PostgreSQL, and the 3rd and final assessment I've got is JavaScript with HTML next so it'll be another learning experience and I'm sure I will do well as for the most part I've comprehended everything and I had prior experience w/ HTML from my Angelfire days.
19-Jan-23 4:29pm
#9
MrBean
GameTZ Gold Subscriber 400 Trade Quintuple Gold Good Trader Gold Global Trader (7) Has Written 1 Review

Archer wrote:
People still use PostgreSQL?
Still? It's one of the most popular out there.
19-Jan-23 4:30pm
#10
MrBean
GameTZ Gold Subscriber 400 Trade Quintuple Gold Good Trader Gold Global Trader (7) Has Written 1 Review

Sorry for the delay @HybridCRoW, sent ya a PM
19-Jan-23 7:33pm
#11
bill
GameTZ Gold Subscriber GameTZ Full Moderator 600 Trade Quintuple Gold Good Trader Has Written 28 Reviews

I know SQL. GameTZ is full of it. I'm far from a SQL expert, though.
21-Jan-23 12:47am
#12
HybridCRoW
GameTZ Subscriber Triple Gold Good Trader Global Trader - willing to trade internationally Has Written 2 Reviews

I finally found what I was looking for, made the changes, and ran the code at least 5 times and each time all consistent good results.

Now I'm doing an assessment for JavaScript with HTML. I hope to have it done this weekend.

Thanks to everyone that was able to help.

Who knows SQL??? Need help