Search results for query: *

hi.. I have a doubt on Group by clause...can anybody explain to me... I have 2 tables..both emp and dept like this: empno ename deptno ------------------ 1 A 10 2 B 20 3 C 10 4 D 10 Deptno Deptname --------------- 10 Comp 20 Phy If i said a...

Hi.. I am a beginer...so i m not having much idea and want to learn things..so can u please check whether this query works or not? select a.* from table1 a, table1 b where a.item=b.item and a.time= select max(time) from b group by itemno;

I think the Insert syntax is wrong...you should use: Insert into tablename values(..). I think u forgot the Values keyword. Thankyou.

please let me know if the issue is resolved.

hi all.. I am able to work with Report Wizard fine..but i want to generate reports manually. Is there any web site that can provide me the information regarding D2K Report editor. Thank you in advance... Also can u suggest me the best web site for PL/SQL. Thank you, Mahesh

Hi..i m also a beginer..we can do this by using self-joins..Consider the table name as Users then try this: select u1.id, u1.user1, u1.user2 from users u, users u1 where u.user2=u1.user1;