21⟩ How to delete Duplicate row in table of Wipro?
SQL> delete from table_name where rowid not in (select max(rowid) from table group by duplicate_values_field_name).
“Wipro Interview Questions and Answers will guide you that Wipro Technologies Limited is a giant information technology services corporation headquartered in Bangalore, India. Wipro is the second largest IT services company in India and employs more than 98,391 people worldwide, so get preparation for a job in Wipro with the help of this Wipro Interview Questions with Answers guide”
SQL> delete from table_name where rowid not in (select max(rowid) from table group by duplicate_values_field_name).
A condition that should return true when a member function is invoked. In order to use a function correctly a precondition should return true. If a precondition fails to hold, an operation will not take responsibility to perform any action of sensibility. For example, the interface invariants of stack class respond nothing about pushing even though the stack is already full. In this scenario, sinful () is a precondition for push operation.
A condition that should return true before returning from an invoked function. In order to use a function correctly a post condition should return true. Taking a stack as an example, is empty () must necessarily be true after pushing the element into the stack when an element is pushed. The function is empty () is a post condition.
It is a process during exception handling when the destructor is called for all local objects between the place where the exception was thrown and where it is caught.
Integer, floating-point, logical, and character arrays are permitted. Floating-point arrays can be complex. For elements of A with identical values, the order of these elements is preserved in the sorted list. When A is complex, the elements are sorted by magnitude, i.e., abs(A), and where magnitudes are equal, further sorted by phase angle, i.e., angle(A), on the interval [−π, π]. If A includes any NaN elements, sort places these at the high end.
B = sort(A,dim) sorts the elements along the dimension of A specified by a scalar dim.
B = sort(...,mode) sorts the elements in the specified direction, depending on the value of mode.
'ascend'
Ascending order (default)
'descend'
Descending order
[B,IX] = sort(A,...) also returns an array of indices IX, where size(IX) == size(A). If A is a vector, B = A(IX). If A is an m-by-n matrix, then each column of IX is a permutation vector of the corresponding column of A, such that
for j = 1:n
B(:,j) = A(IX(:,j),j);
end
If A has repeated elements of equal value, the returned indices preserve the original ordering.
Example:Sort horizontal vector A:
A = [78 23 10 100 45 5 6];
sort(A)
ans =5 6 10 23 45 78 100
Syntax
B = sort(A)
B = sort(A,dim)
B = sort(...,mode)
[B,IX] = sort(A,...)
Description
B = sort(A) sorts the elements along different dimensions of an array, and arranges those elements in ascending order.
If A is a ... sort(A) ...
Vector Sorts the elements of A.
Matrix Sorts each column of A.
☼ Multidimensional array Sorts A along the first non-singleton dimension, and returns an array of sorted vectors.
☼ Cell array of strings Sorts the strings in ascending ASCII dictionary order, and returns a vector cell array of strings. The sort is case-sensitive; uppercase letters appear in the output before lowercase. You cannot use the dim or mode options with a cell array.
A class does not inherit constructors from any of its super classes.
Static modeling is used to specify structure of the objects that exist in the problem domain. These are expressed using class, object and USECASE diagrams. But Dynamic modeling refers representing the object interactions during runtime. It is represented by sequence, activity, collaboration and statechart diagrams.
A property is a member that provides access to an attribute of an object or a class. Examples of properties include the length of a string, the size of a font, the caption of a window, the name of a customer, and so on.
It is an object of some class whose purpose is to indicate that a real object of that class does not exist. One common use for a null object is a return value from a member function that is supposed to return an object with some specified properties but cannot find such an object.
Dynamic modeling refers representing the object interactions during run-time. It is represented by sequence, activity, collaboration and state-chart diagrams.
There are 5 operators which cannot be overloaded. They are:
★ .* - class member access operator
★ :: - scope resolution operator
★ . - dot operator
★ ?:: - conditional operator
★ Sizeof() - operator
Note:- This is possible only in C++.
The Document Object Model (DOM) is a cross-platform and language-independent convention for representing and interacting with objects in HTML, XHTML and XML documents.[1] Objects in the DOM tree may be addressed and manipulated by using methods on the objects. The public interface of a DOM is specified in its application programming interface (API).
Passive objects are one, which passively waits for the message to be processed. It waits for another object that requires its services. In simple words it can be referred as server.
Static modeling is used to specify structure of the objects that exist in the problem domain. These are expressed using class, object and USECASE diagrams.