kozmo101 Posted November 8, 2012 Share Posted November 8, 2012 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 More sharing options...
niche Posted November 8, 2012 Share Posted November 8, 2012 (edited) Yes, assuming "Search Results: SalesAssistant, James Kazukin, UniversityofVictoria " is NOT part of your query and table names and column names are spelled correctly.. Edited November 8, 2012 by niche Link to comment Share on other sites More sharing options...
thescientist Posted November 8, 2012 Share Posted November 8, 2012 (edited) 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 November 8, 2012 by thescientist Link to comment Share on other sites More sharing options...
kozmo101 Posted November 8, 2012 Author Share Posted November 8, 2012 Great, thanks guys! Link to comment Share on other sites More sharing options...
niche Posted November 8, 2012 Share Posted November 8, 2012 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 More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now