ratnababunarne
Last Activity: May 29 '07, 08:55 AM
Joined: May 16 '07
Location:
-
difference between count(*) and count(1)
difference between count(*) and count(1) -
select query
take emp table this query
my required output is
dept wise manager wise employees
i.e
deptno=10 -deptno
7655 smith manager 3000 -manager
4567 martin clerk 1200 - emp details
Plz send me That Query -
Thanks Pradeep..I know one new query today.. -
Update Query Doubt
I have a table A .
These two tables have the column Gender.
I entered data into it.
unfortunately i entered Gender column data wrongly as Instead of M i entered F and instead of F i entered M.
How can i update my table correctly.
update A set gender='M' where gender='F';
update A set gender='F' where gender='M';
after second query all the gender column values as F
What is the solu...
No activity results to display
Leave a comment: