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
- 12359 Views
- Cap Gemini, CGI, EDS, IBM, Satyam, Wipro, I also Faced
- E-Mail Answers
Answer Posted / venu
Select * from employment table where salary between 1000 to
50000
| Is This Answer Correct ? | 4 Yes | 8 No |
Post New Answer View All Answers
What is the difference between cursor stability and repeatable read isolation levels?
Mention the definition of cobol in varchar field.
Mention the length of physical storage of the given data types of db2 – date, timestamp, time
Mention the downsides of page level lock.
How to check table size in db2 sap?
Why do chiropractors use drop table?
What is an instance in db2?
What is difference between rollback and commit?
what is the sqlcode -501
what is diffrence b/w file-aid tool and file-aid utility???
Why do we need reorg in db2?
What is bind and rebind in db2?
How to find primary key of a table in db2?
Which command is used to connect to a database in DB2 ? Give the Syntax.
How do I delete a table in database?
