Interested to Buy Any Domain ? << Click Here >> for more details...
How do you retrieve the first 5 characters of firstname column of db2 table emp?
- 1 Answers
- 1959 Views
- I also Faced
- E-Mail Answers
Answer / ankit
Select substr(firstname,1,5) as firtname from emp;
| Is This Answer Correct ? | 0 Yes | 0 No |
Why do we need to create an alias if we can directly use the table name? What are the benefits of referring a table name by its alias? Also, when should we go for alias and when for synonyms?
What is query for your birthday date should be in hours,minute and seconds format?
What is the difference between oracle and db2?
How to solve S0C7 abend with out using DISPlay in 10 mins?
What are the contents of a dclmgen?
How do I create a view in db2?
What is a storage group (stogroup)?
How many databases can be created inside an instance in db2 ?
db2 query I have one table with the following details. SNO SNAME DOJ ------ -------------------- ---------- 10 KRISH 2007-03-19 20 REDDY 2007-05-19 30 RRRRR 2007-05-19 40 BBBBB 2008-05-19 50 CCCCC 2009-05-19 60 JJJJJ 2009-05-19 70 JJJJJ 2004-05-19 i want the output in the following format:( no of students joined in each year(no nedd to consider about month and date) year count --------- ---------- 2004 1 2007 3 2008 1 2009 2
Can DASD types assigned to storage groups be intermixed (i.e., 3350s and 3380s)?
If we have 100 records in the PF, we deleted all the records then what is the Size of the PF?
What do you do to keep the cursor from closing after a commit?
COBOL 
