Hi,
Do anyone know a query for the following senario,
I have a table in which i have multiple rows with the same entry. I want to keep only one copy of such rows. How to write a query to delete all the duplicate rows and have only one entry for such with a single query???
For example
[code=oracle]
create table Employee
{
empno char(5),
name varchar2(20),
salary...
ranjitkumar
Last Activity: Nov 17 '06, 03:30 PM
Joined: Nov 2 '06
Location:
-
Query to eliminate dulicate rows
-
Query to find the third largest row in a table
Hi everybody,
create table employee
{
empno char(5) primay key,
name varchar2(30),
salary number(5,2)
};
1. For the above table how to find the employee with the third highest salary. -
print 1 to 100 without loops in c/c++
Hi,
If any one know the answer for the following questions
Write a C++ program without using any loop (if, for, while etc) to print numbers from 1 to 100 -
How to invoke a method with same name as class
Hi,
I read in a book that it is perfectly legal to declare a method with same name as class. If that is possible, How to invoke that method???
For example,
Class A
{
public :
void A(){ } // Legal method with same name as class.
A(){} // default constuctor
}
If anybody knows the answer please let all of us know. -
No activity results to display