topic Re: SQL statements in Application Development and Automation Discussions

SQL statements

Former Member — Sun, 13 Mar 2005 02:55:43 GMT

I want an overview of all SQL statements.

Thanks in advance

Aksher

Re: SQL statements

Former Member — Sun, 13 Mar 2005 07:28:57 GMT

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

Re: SQL statements

Former Member — Sun, 13 Mar 2005 12:17:06 GMT

Or perhaps, this one ?

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

Regards,

Anand Mandalika.

Re: SQL statements

Former Member — Mon, 14 Mar 2005 06:18:57 GMT

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.

Re: SQL statements

Former Member — Sun, 20 Mar 2005 07:30:51 GMT

hi Zaffar

My email ID is aksher_i@rediffmail.com

Regards

Aksher

Re: SQL statements

Former Member — Mon, 21 Mar 2005 08:53:35 GMT

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

bye

Rai Zeeshan Zaffar Khan.