SQL statements

[Former Member]

Hi

I want an overview of all SQL statements.

Thanks in advance

Aksher

[Former Member]

Hi Aksher,

Please try out the following link.

http://help.sap.com/saphelp_46c/helpdata/en/d3/2e974d35c511d1829f0000e829fbfe/frameset.htm

hope it helps!!

Regards,

Sandeep Soman

[Former Member]

Or perhaps, this one ?

http://help.sap.com/saphelp_46c/helpdata/en/c9/5472f9787f11d194c90000e8353423/content.htm

Regards,

Anand Mandalika.

[Former Member]

Dear

syntext of Basic Select Statement

-

---

SELECT *|{[(DISTINCT] column|expression[alias], ...}

FROM table

SELECT ALL COLUMNS

-

---

SELECT * FROM table_name.

SELECT SPECIFIC COLUMNS

-

---

SELECT column1,column2,column3,column3

FROM table_name.

FILTER ROWS FROM A TABLE

-

---

SELECT * FROM employee

WHERE date_of_joining='20-MAR-2004'

SELECT * FROM employee

WHERE emp_name LIKE 'S%'

SELECT * FROM employee

WHERE DETPNO=10

SELECT * FROM employee

WHERE JOB='MANAGER'

In addition we have joins subqueries. if you feel the upper information guide you better i will send you some example of joins and subqueries

ok dear

in addition i have a very good ebooks on SQL. send me your email i will mail you.

thanks

Rai Zeeshan Zaffar Khan.

[Former Member]

hi Zaffar

My email ID is aksher_i@rediffmail.com

Regards

Aksher

[Former Member]

dear wait 4 tommorrow i will send it to u sorry for delay i was much busy.

bye

Rai Zeeshan Zaffar Khan.