Here are a few examples of how you can use the search feature:

Entering this and that into the search form will return results containing both "this" and "that".

Entering this not that into the search form will return results containing "this" and not "that".

Entering this or that into the search form will return results containing either "this" or "that".

Search results can also be filtered using a variety of criteria. Select one or more filters below to get started.

Assuming rownum is required, the following 6 results were found.

  1. Cheat Sheet for mySQL vs t-SQLhttps://joellipman.com/articles/database/cheat-sheet-for-mysql-vs-t-sql.html

    expression,value_if_true,value_if_false ) If Null IFNULL(column_name,value_if_null) ISNULL(column_name,value_if_null) Rank/Rownum (@rownum:=@rownum+1) AS Rownum LIMIT from_index, number_of_rows ROW_NUMBER() OVER(ORDER BY column_name ASC) AS Rownum...

    • Type: Article
    • Author: Joel Lipman
    • Category: Databases
    • Language: *

  2. Split a row into multiple rows based on a column valuehttps://joellipman.com/articles/database/t-sql/split-a-row-into-multiple-rows-based-on-a-column-value.html

    2, 1000) AS Items , ROW_NUMBER() OVER (PARTITION BY EmployeeNo, DateOfSickness ORDER BY EmployeeNo, DateOfSickness) AS Rownum FROM Employees_Attendance_Table JOIN master..spt_values n ON n.type = 'P' AND n.number...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: *

  3. No rows returned in Oracle causes SP to failhttps://joellipman.com/articles/database/pl-sql/no-rows-returned-in-oracle-causes-sp-to-fail.html

    me, the answer was using two NVL functions which allowed the stored procedure to return no rows without erroring (ie. where rownum/rowcount = 0). Consider the following: SELECT NVL(student_accounts.studentID, 0) INTO v_studentreference FROM...

    • Type: Article
    • Author: Joel Lipman
    • Category: Oracle PL/SQL
    • Language: en-GB

  4. MySQL Oracle equivalentshttps://joellipman.com/articles/database/mysql-oracle-equivalents.html

    from sys.dba_tables - Return a specific number of rows SELECT * FROM table1 LIMIT 0, 10 SELECT * FROM table1 WHERE ROWNUM

    • Type: Article
    • Author: Joel Lipman
    • Category: Databases
    • Language: en-GB

  5. Basic Oracle Function Structurehttps://joellipman.com/articles/database/pl-sql/basic-oracle-function-structure.html

    -ERROR- '||SQLERRM); END fn_get_sref_from_adname; To run this: SELECT fn_get_sref_from_adname('f2574687') from dual where rownum

    • Type: Article
    • Author: Joel Lipman
    • Category: Oracle PL/SQL
    • Language: en-GB

  6. Data Randomization Function in Oracle PL/SQLhttps://joellipman.com/articles/database/pl-sql/data-randomization-function-in-oracle-plsql.html

    'DATE','01/01/1000','31/12/1002') random_daterange -- testing date range FROM UFN_STUDENT_ACCOUNTS WHERE ROWNUM

    • Type: Article
    • Author: Joel Lipman
    • Category: Oracle PL/SQL
    • Language: en-GB
Results 1 - 6 of 6

Donate & Support

If you like my content, and would like to support this sharing site, feel free to donate using a method below:

Paypal:
Donate to Joel Lipman via PayPal

Bitcoin:
Donate to Joel Lipman with Bitcoin bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4

Ethereum:
Donate to Joel Lipman with Ethereum 0xb038962F3809b425D661EF5D22294Cf45E02FebF

Joes Word Cloud

Please publish modules in offcanvas position.