All this talk of SQL queries and computer gaming is scaring folks away from NGC. Actually, the more frightening possibility is that it might be attracting people to the NGC...

 

well in theory it would make more sense if it were to just get top 100 records:

SELECT top 100 * from DBUsers.dba.Users_Table WHERE member_club='National G Club' AND occupation='Terrorists')

This is assuming DBUsers is the database name and Users_Table is the table having all usernames and member_club and occupation are actual columns in said table

 

LOL, thanks for the refresher course...i just got depressed...all that money spent and time on learning this ish and so quickly i forgot....at least with a solid background it should be easy to pick up again.

pratik, your code is correct, but i think in some software your punctuation may be lacking . for ex. i think access sql requires use of a semi colon after the first line?? i think yours is oracle sql?? i dunno its been so long, but its actually interesting looking at your guys' code b/c it brings back some good memories!!

 

i need to apply for a job where i can use SQL, i thikn in 2 hrs i could prob. get it all back...

 

Well technically I forgot the beginning ( in my code but whatever and no, i'd be running something liket hat in SQL Enterprise Manager on a DB I have and no punctuation required running the query.

You'd need those semicolons in C++, C# code though!!

 

I was assuming there was a terrorist column for you and puria :P. Eat that foreigner :P hah all in good fun. You can always call me a mick bastard. :P Or Armenian ******* or something :P.

I came into my job thinking I was going to use SQL given that they had me take a theoretical problem-solving test and a SQL test. Yet I have not used any of my SQL knowledge. I should of gone for a developer or DBA position.

 

I think you need a semicolon at least in MS SQL after the entire query is finished so after the last FROM statement if it's a query. But yes you definitely need it in C, C++, C# and JAVA. Does anybody remember if you needed a semicolon in LISP (AI language)? I can't remember...

 

Select * from NationalGClub where NGC_Membership_Active = 'y' and Active_Hookah_Smoking = 'y' order by Top_Smoker

 

wow way too much technical talk for this early

 

man i loved sql back at mason, i think im willing to take a 5k pay cut to get a job where i can actually use it....much better than sitting here on my a$$ talking to you gay ****'s on IM or posting every 3 min!!

 

You sure about that?