Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

Write a query to extract first 5 characters of a name in the column Stud_Name?

Answer Posted / shubham

select substr(Stud_Name,1,5) from Table;

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Which components manage deadlocks in db2?

1124


What is table space in db2?

1072


Is db2 a database?

1027


How to create db2 table in mainframe?

1217


What is multi row fetch in db2?

1102


How can the duplicate values be eliminated from db2 select?

1159


List out the three types of page locks that can be held.

1193


How would the varchar column remarks defined?

1130


What does db2 mean?

1084


What is deadlock in db2?

1122


When the like statement is used?

1281


Is db2 a mainframe?

1096


What is the use of value function?

1209


What is cursor in dbms?

1113


I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?

2440