Interested to Buy Any Domain ? << Click Here >> for more details...
i have an employment table whch has salary,dept,name? i want
salary b/w 1000 to 5000 can anyone pls say the query for ths ?
- 8 Answers
- 13797 Views
- Cap Gemini, CGI, EDS, IBM, Satyam, Wipro, I also Faced
- E-Mail Answers
Answer Posted / deepak
Select * from employment table where salary between 1000 to
50000
| Is This Answer Correct ? | 25 Yes | 7 No |
Post New Answer View All Answers
Why do we need reorg in db2?
Before you give the explain statement, what are the prerogatives?
How can the duplicate values be eliminated from db2 select?
ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE
List out the three types of page locks that can be held.
What is a dbrm in db2?
What are the 2 sqlcodes that are returned?
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
How do I delete a column in db2?
Are view updateable?
What do you mean by storage group (stogroup)?
Explain package in db2 and its advantages?
What is a Foreign Key?
How does db2 sample database connect?
Explain correlated sub-queries.
