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
- 14164 Views
- Cap Gemini, CGI, EDS, IBM, Satyam, Wipro, I also Faced
- E-Mail Answers
Answer Posted / dinesh
option 1:
Select * from empoyment table where salary >=1000 and <=50000
option 2:
select * from employment table where salary between 10000 and 50000
| Is This Answer Correct ? | 4 Yes | 3 No |
Post New Answer View All Answers
How to resolve deadlock issue
What is innodb buffer pool?
what is the responsibility of the construction superintendent
In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?
What is buffer pool?
How do you simulate the explain of an embedded sql statement in spufi/qmf?
How to rename a table in DB2 ?
How to execute stored procedures?
Can we insert update delete in view?
How to access db2 tables in mainframe?
Explain the contention situations caused by locks?
What is a plan and package in db2?
What is the use of with ur in db2?
What is the difference between oracle and db2?
What is database reorganization?
