Jump to content

Is this SQL code good?


kozmo101
 Share

Recommended Posts

Hi, I'm hoping that someone with some SQL experience can let me know if this value set is good? I'm applying for a job that requires basic - intermediate SQL jobs and I just started teaching myself. Example: SELECT ApplicationID, Firstname, Lastname, UniversityFROM ApplicationsWHERE (University = ‘UniversityofVictoria’) AND (ApplicationID = ‘SalesAssistant’) Search Results: SalesAssistant, James Kazukin, UniversityofVictoria If I wanted to run this data value as a company would this be correct?

Link to comment
Share on other sites

Yes, assuming "Search Results: SalesAssistant, James Kazukin, UniversityofVictoria " is NOT part of your query and table names and column names are spelled correctly..

Edited by niche
Link to comment
Share on other sites

Yes, assuming "Search Results: SalesAssistant, James Kazukin, UniversityofVictoria " is NOT part of your query and table names and column names are spelled correctly..
that's an example result from running that query... Edited by thescientist
Link to comment
Share on other sites

That's what I thought too. I just needed to be absolutely sure since his employment's depending on the answer.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...