Search In
ROW_NUMBER()
RANK()
DENSE_RANK()
All of these three functions are used to calculate the Id of row but in different way.
I am using the below script for examples
CREATE TABLE Marks
(
SubjectId INT,
Marks INT
)
INSERT INTO Marks VAL
Instance Initializer Block:
There are two types of data members: static and instance data members.
Instance data members are those that belongs to instance of a class. i.e objects. Here comes the role of instance initializer block. It is used
We can set up a computer network by just arranging computers by some means together with the use of cabels and just installing the network interface card NIC in each terminal so that plug can work.
Then the operating system
Json object:
You easily write your object in json format with java . Json format is used because it becomes easy to exchange information in this form. It is easy to understand and easy to write.
Lets see an example,
If you are usin
Management is an art to deal people. Managers must be good listeners, motivator, friend who deal with ease and trust with his/her sub-ordinates. Managers must be a good team player who should always boost team spirit. Various managers have
Sometimes our requirement is to export/download the latest database from live/test server.
We can easily create the dump on our server and then copy paste it from server to your local machine using Win-Scp.
But the issue comes when the size o
Laravel 4.x provide n number of sending email library such as mandrill,sendgrid etc. These all library are used to send bulk email. To use Sendgrid in our Laravel project we have to follow few steps. By this way we can implement Sendgrid in our Larav
Hi Reader's,
Welcome to FindNerd, today we are going to discuss how to append/add and remove input field in a form with just on a click?
In this blog we will see how to append text input fields in a HTML form using jQuery and process the s
Welcome to Findnerd. Today we are going to discuss the concept of multiplexing in networking. Please have a look.
Multiplexing
Multiplexing is nothing but a process or a way to transmit the two or more signals over a communication channel at the sa
Hello Everyone,
As we know that in almost all web applications there are certain things which need validations to be performed on
them. Validations can be performed in two ways that is client side and server side.
Client side validations are perfo
