Palindrome

Palindrome Problem

A palindrome is a word that reads the same both forwards and backwards.

Examples: anna, nitalarbralatin, amanaplanacanalpanama.

Program -

#include<iostream.h>

#include<conio.h>

#include<string.h>

#include<stdio.h>

void main()

{char a[20],b[20];

cout<<"enter the string"<<endl;

gets(a);

strcpy(b,a);

strrev(b);

if(strcmpi(a,b)==0)

cout<<"palindrome"<<endl;

else

cout<<"nay"<<endl;

getch();

}

SQL Select Command

SQL STATEMENT

SELECT Statement

The SELECT statement is used to select data from a database.

The result is stored in a result table, called the result-set.

 Syntax -

SELECT column_name(s) FROM table_name

and

SELECT * FROM table_name

 Note: SQL is not case sensitive. SELECT is the same as select.

 SELECT DISTINCT Statement

In a table, some of the columns may contain duplicate values. This is not a problem, however, sometimes you will want to list only the different (distinct) values in a table.

The DISTINCT keyword can be used to return only distinct (different) values.

 Syntax -

SELECT DISTINCT column_name(s) FROM table_name

The WHERE Clause

The WHERE clause is used to extract only those records that fulfill a specified criterion.

Syntax -

SELECT column_name(s) FROM table_name WHERE column_name operator value

The ORDER BY Keyword

The ORDER BY keyword is used to sort the result-set by a specified column.
The ORDER BY keyword sort the records in ascending order by default.
If you want to sort the records in a descending order, you can use the DESC keyword.

 Syntax -

SELECT column_name(s) FROM table_name ORDER BY column_name(s) ASC|DESC