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...

muhammed zaheer


{ City } bahrain
< Country > india
* Profession * programmer
User No # 13277
Total Questions Posted # 0
Total Answers Posted # 3

Total Answers Posted for My Questions # 0
Total Views for My Questions # 0

Users Marked my Answers as Correct # 92
Users Marked my Answers as Wrong # 19
Questions / { muhammed zaheer }
Questions Answers Category Views Company eMail




Answers / { muhammed zaheer }

Question { 14377 }

pls explain connect by prior with example and its real time
use


Answer

Connect by prior can be used to create heirarchical tree
structure

Is This Answer Correct ?    6 Yes 3 No

Question { Cognizant, 361471 }

how to find the second highest salary from emp table?


Answer

select max(sal) from emp where sal < (select max(sal) from
emp)

Is This Answer Correct ?    86 Yes 16 No


Question { 4961 }

Is it possible to enter only time value into a column of a
table in sql?


Answer

No,
you can store as (HH24:MI) at form level, also make format
DateTime.
Query by - to_date(HH24:MI)
Also you can use Timestamp - I tied it in Oracle 10g. It
will store date and time


Is This Answer Correct ?    0 Yes 0 No