sql query question

eurotrotter

hi guys
hope ye all had a good wkd
have a SQL query question here:

5) Write the SQL script to determine how many years an employee has worked
in the company (emp table)

Select ename "Name", hiredate ,round((months_between(sysdate,hiredate))/12) "Years in company"
From emp
Where ename = ‘&Name’;


see the last line there; Where ename = ‘&Name’;
why is this lin eneeded, i mean wat does it do

thanks for yer time
ed

stipey

Seems like a homework question?

eurotrotter

its solution that the lecturer did out in the notes
but i am looking at it now and cant figure out why this last line i snecessary

azzeretti

In any query you will always need a "hook" to pull the required data out, this usually comes from a WHERE clause. The query below is saying as follows:

Go to the emp table and get me back the Name, Hiredate and Years In Company but to get this information look at the ename column and only pull back this information when ename is equal to &Name.

I can only guess what the &Name is in this query. If I had to guess I would say this is a variable for you to fill in e.g Select * from emp where name ="Smith" would pull back everything in the table where Name is = Smith.

Mind you, this depends on the SQL database you are using. Most transact SQL is similar, but not identical, so the &Name could mean something else in a propriatory DB. I'd assume its a variable though, unless & is a wildcard in this DB etc/

narcissism

its a variable, usually populated by user input via a parameter.

Khannie

moving to programming....