[Oracle]Need help writing this query in a different way.[Should be very easy]

Hello,

Is there another way to write this without using either 'in' or 'or'

select * from emp where hiredate in(2-jan-92,2-jan,93,2-jan-95)

I know this is a bit of a weird question but it was a bonus question in my class right now and I really believe there is no solution. No one solved it and the prof didn't either.



Submitted December 31, 2017 at 06:49PM by Ravingsmads http://ift.tt/2CfNLeF

Comments

Post a Comment

Popular posts from this blog

certain keys on my keyboard dont work when "cold"

Hi guys, i have a Lenovo Y520-15IKBN (80WK) and certain keys on the keyboard don't work (e,g,h,8,9,Fn...) but only when the weather is cold. for example in the winter it used to work after certain amount of time when i first boot the laptop and stops working when i stop using it for a while, but now that the weather is hot it works just fine except for the first couple of minutes or when its colder. of course i do realise that it has nothing to do with the outside weather but with the temperature of the computer itself. can someone explain to me why this is happening and how it should be fixed as i cannot take it to the tech service until july even though it's still under warranty because i need it for school. ps: an external keyboard works fine. Submitted April 29, 2018 at 03:35PM by AMmej https://ift.tt/2KiQg05
Read more

Old PC with a Foxconn n15235 motherboard needs drivers! Help!!

So my Pc corrupted and I had to fresh install windows on it, but now its missing 3 drivers and one of them is for the Ethernet controller! I've tried searching everywhere for the windows 7 drivers but all I seem to find are some dodgey programs saying they will install it for me. Problem is without the ethernet driver I can't bloody connect to the internet. I've been using a USB to try get some drivers on there, but they just end up being useless programmes . I'm also a bit of a noob at these things, I don't understand where to find the names of things in my PC, I've opened it up but I don't understand whats significant and what isnt. If someone has the drivers and can teach me how to install them I'd be very appreciative! Submitted April 29, 2018 at 02:47PM by darrilsteady https://ift.tt/2r76xMZ
Read more

"nvfbc plugin window" preventing Windows 10 shutdown.

So yeah, the title says it all.. When i try to shut down or restart my PC, I get a screen saying a program is preventing shut down. But I don't know what to do to fix it. I found a script on a steam forum about how to disable or enable NVFBC but that doesn't have any effect. Any ideas? Submitted January 19, 2018 at 12:40AM by Wickedld http://ift.tt/2DsOvwR
Read more