Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: MadhanaGopal
- Content: Threads
- Order by date
-
Varchar vs Varchar2
Hi, I am new to oracle and i am having the following basic doubt. 1.Differnce between Varchar and Varchar2 data types. ( As of my knowledge varchar is deprecated in oracle 9i and memory management is different btw varchar and varchar2.i am not sure about it) 2.Locking Mechanism in Oracle...- MadhanaGopal
- Thread
- Replies: 2
- Forum: Oracle: All versions
-
Select Max count(*) problem
Hi, I have one requirement. select fld1 as col1 ,fld2 as col2,max(fld3) as col3 , count(*) as col4 from table1 group by fld1,fld2 It gives the result as col1 col2 col3 col4 ------------------------------------------ A B 25 5 A B...- MadhanaGopal
- Thread
- Replies: 4
- Forum: Microsoft SQL Server: Programming
-
To find n th Maximum
In a following Table , Table : order Fields: order Id value i want to find the 'n' th maximum value of order using a single query. Thanx in Advance. P.Madhana Gopal, Principal Software Engineer, LCube Innovative Solns. Pvt. Ltd., India.- MadhanaGopal
- Thread
- Replies: 3
- Forum: Microsoft SQL Server: Programming
