thank amit .
can you tell me the otherways so that i could get the knowledge of that too....
sinner
Last Activity: Feb 16 '09, 01:27 PM
Joined: Mar 3 '08
Location:
-
hi,
i used a query to retrive the top product sold by a particular user by the following
query:
select tab1.name,x.cnt post from (SELECT tab2.id,count(t ab2.post) cnt from tab2 group by tab2.id ) x,tab1 where tab1.id = x.id order by post desc;
it works fine.
can i get get more feesable query to retrive the value....Leave a comment:
-
Thanks amitpatel for the code.It is working fine....Leave a comment:
-
Thanks for the query its work fine.
i faced a problem when i tried to know the number of products sold by a particular emp_id
ie
select t1.name,count(p rod) from t1,t2 group t2.id;
The error was not a GROUP BY expression.
what can i do for retriving name and product count from the table.Leave a comment:
-
Thanks for the query its work fine.
i faced a problem when i tried to know the number of products sold by a particular emp_id
ie
select t1.name,count(p rod) from t1,t2 group t2.id;
The error was not a GROUP BY expression.Leave a comment:
-
query
hi,
i faced a problem when i tried to retrive value from two table using a common value.
ie
table1 has emp_id and name,table2 has emp_id and prod..
i tried to use the query
select name,prod from table1,table2 where table1.emp_id=' some value';
The problem was there was redundancy of data in table2 and using distinct key word also i got unwanted values.
ie.
select distinct name,prod from table1,table2... -
thanks for the code
regards...Leave a comment:
-
thanks i will carry onfrom here...Leave a comment:
-
springs using net beans
hi
iam using netbeans ide to run the springs framework with apache tomcat server.
i encountered a error when i ran through the program
javax.servlet.S ervletException : java.lang.NoCla ssDefFoundError : org/apache/commons/el/ExpressionEvalu atorImpl
i have imported all the jar files.
can anyone guide me in this problem. -
yes what you summarized is perfect please help me with that problem....Leave a comment:
-
i haven't decided with that. if so the can you help me with the code.Leave a comment:
-
Its something like we want to fetch the datas from database, so that we want to display as 10 records in a table. For each insert in the table this page needs to be refreshed with the recent .
Regards...Leave a comment:
-
thanks for the reference...Leave a comment:
-
page refresh
hi
iam new to this javascript.
i want to know how to refresh a page
ie.I want my page to get refreshed based on the updatation made in the database.
can anyone guide me with the sample code or reference. -
using clob
hi.
i want the code or reference for insert command using the CLOB datatype.
No activity results to display
Leave a comment: