merimaheen
asked on
select count(*),count(*) from emp,dept
I want the results like that
emp dept
14 4
instead of
select count(*) from emp;
14
select count(*) from dept;
4
I want one sql statement to find the number of rows in all the tables for a user.
can you help me??
emp dept
14 4
instead of
select count(*) from emp;
14
select count(*) from dept;
4
I want one sql statement to find the number of rows in all the tables for a user.
can you help me??
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks