Call Support +91-85588-96644
TCY online

Login

Sign Up

Please enter a Username or Email ID
Please enter a password
Keep me logged in
Please enter your name
Please enter your mobile number
You can't leave Captcha Code empty
By submitting this form, you agree to the Terms & Privacy Policy.
OR

Sign Up via Facebook

Sign Up via Google

Sign Up via Twitter

Download Software
Tests given

Download TCY App

OR
App Image
Discussion

Official Java/Oracle /C/C++ Preparation for Information Technology

Shared from Database on Dec 14, 2017 7:36 PM



In the above table named Emp, how can the information of the employee who is working in the IT department be extracted?

 
Select * from emp where dept='IT';
Select * from emp where sal>20000 and sal<36000;
Select * from emp where dept=IT;
Both 1 and 2
None of these

Reply


Please type your answer before submitting.
Submit

Hi , pls let me know, how u are executing this query?

I got below error ORA-00904: "IT": invalid identifier 00904. 00000 - "%s: invalid identifier"