Blog Posts - Sql Queries



SQL Query to Find nth MIN and nth Max Salary

SQL Query to Find nth MIN and nth Max Salary Continue reading →...

5 More Frequently Asked DB2 SQL Queries

I collected from my friends, for DB2 interviews these SQL queries you need to practice more times. Query#1 1) What are the different SELECT statements? A. select clause: Enumerates the column names and related constructs from clause: Describes the ta...

Pluralsight – Optimizing SQL Queries in Oracle

Description: This course introduces SQL programmers and new Oracle database administrators to several methods to make SQL queries execute faster. This course introduces SQL programmers and new Oracle database administrators to several methods to make...
by tutgfx on Apr 16, 2014

CURSOR_ROWS function in Sql Server

@@CURSOR_ROWS function returns number of rows currently in the last opened cursor. The number returned by @@CURSOR_ROWS is negative if the last cursor was opened asynchronously. Keyset-driver or... SQL is a standard interactive and programming langu...
by Structured Query Language on Mar 4, 2013

FETCH_STATUS function in sql server

@@FETCH_STATUS function determines whether FETCH keyword has successfully retrieved a row from the current cursor. The value of @@FETCH_STATUS is undefined before any fetches have occurred on the... SQL is a standard interactive and programming lang...
by Structured Query Language on Mar 4, 2013


Trending Topics

Close