Difference between DISTINCT versus DISTINCTROW SQL Keywords


DISTINCT : DISTINCT checks only the fields listed in the SQL string and then eliminates the duplicate rows. Results of DISTINCT queries are not updateable. They are a snapshot of the data.
DISTINCT queries are similar to Summary or Totals queries (queries using a GROUP BY clause).

DISTINCTROW: DISTINCTROW, on the other hand, checks all fields in the table that is being queried, and eliminates duplicates based on the entire record (not just the selected fields). Results of DISTINCTROW queries are updateable.

Related Posts:

  • Difference between Literal Control and Label Control Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4 … Read More
  • Bubble Sort Bubble sort [string array] #include <stdio.h> #include <stdlib.h> #include <string.h> #define MAX 50 #define N 2000 void sort_words(char *x[], int y); void swap(char **, char **); int main(void) {  … Read More
  • SQL Objective Type Question and Answers Database Objective Type  Question and Answers Q.1 In the relational modes, cardinality is termed as: (A) Number of tuples. (B) Number of attributes. (C) Number of tables. (D) Number of constraints. Ans: A Q.2… Read More
  • SQL 1. The _____ states that a foreign key must either match a primary key value in another relation or it must be null. (a) entity integrity rule (b) referential integrity constraint (c) action assertion (d) composite attribute… Read More
  • SQL Objective Type Question & Answers For Interview Q.1An entity set that does not have sufficient attributes to form a primary key is a (A) strong entity set. (B) weak entity set. (C) simple entity set. (D) primary entity set. Ans: B Q.2 Errors occur more often when a. data… Read More

0 comments:

Post a Comment