How do you retrieve the first 5 characters of FIRSTNAME column of EMP table ?
SELECT SUBSTR(FIRSTNAME,1,5) FROM EMP;
If you liked this question/asnwer, make sure you
Subscribe to KyaPoocha.com RSS feed!
BOOKMARK THIS : BlinkList | del.icio.us | Digg it | Furl | reddit | StumbleUpon | Yahoo MyWeb |
Related Interview Questions
How can I make a custom rule, or a list with custom bullets? 11.11.08
There was a proposal in the now-expired HTML 3 draft to handle exactly this: just add SRC to the or tag, indicating where the image can be found. But until...How can I make a custom rule, or a list with custom bullets? 11.11.08
There was a proposal in the now-expired HTML 3 draft to handle exactly this: just add SRC to the or tag, indicating where the image can be found. But until...What is the difference between CHAR and VARCHAR data types? 06.11.08
CHAR is a fixed length data type. CHAR(n) will take n characters of storage even if you enter less than n characters to that column. For example, "Hello!" w...What is the maximum length of a table name, a database name, or a field name in MySQL? 06.11.08
Database name: 64 characters Table name: 64 characters Column name: 64 characters...How can I make a custom rule, or a list with custom bullets? 09.09.08
There was a proposal in the now-expired HTML 3 draft to handle exactly this: just add SRC to the or tag, indicating where the image can be found. But until...What are the column name qualifiers ? 14.07.08
A column name qualifier are used as a table designator to avoid ambiguity when the column names referenced exists in more than one table used in the SQL stateme...What is the syntax for a CREATE TABLE statement ? 14.07.08
CREATE TABLE table name (column name list primary key (column name)) in database-name, tablespace-name....What are column-name qualifiers used ? 09.04.08
Column-name qualifier are used as table designator to avoid ambiguity when the column names referenced exist in more than one table used in the SQL statement. C...What DB2 Catalog column tell you when an index needs table reorganized ? 09.04.08
The FAROFFPOS column of the SYSIBM.SYSINDEXPART table....can I alter a table (e.g. adding a column) when other user is selecting some columns or updating some columns from the same table? 21.03.08
yes possible. until the updation or selection is committed db2 table will not be restructured. new column definition will be there but it will not be included u...