INSERT Into

Örnek
Şöyle yaparız.

insert into tableX(id, contact_no, name, description)
                -- 1st 2nd         3rd   4th
values(1st, 2nd, 3rd, 4th);

ROW_NUMBER

Giriş
ROW_NUMBER() OVER(ORDER BY Sütunİsmi) as ROW_NUM olarak kullanılır.

Örnek
Sayfalama için şöyle yaparız.

SELECT * FROM (
    SELECT

      ord.*,

      row_number() over (ORDER BY ord.order_id ASC) line_number
    FROM Orders ord
  ) WHERE line_number BETWEEN 0 AND 5  ORDER BY line_number;