in the select clause there are few keywords like SELECT, FROM, WHERE, GROUP BY, HAVING, ORDER BY.. i would like to know execution of the select statement means which one executes first out of these keywords and their execution sequence.

Why do we need a DDL and DML in a database system?

laikka_buddy

 Profile Answers by laikka_buddy Questions by laikka_buddy

• May 5th, 2008

DDL  is  nothing   but   Data  Definition  Language .  It is very important for a  dadabase that we have to  define  the data   such that  we can  create tables , alter tables, truncate  and  drop  tables

ugly1

 Profile Answers by ugly1 Questions by ugly1

• Jan 25th, 2008

DDL stands for data definition language and DML stands for data manipulation language.DML changes data in an object (eg-insert,update,delete) and when we create,change or remove a database object thats DML (eg-create). so both are important.

Answer Question  Select Best Answer

kmuddana

 Profile Answers by kmuddana Questions by kmuddana

• Apr 30th, 2008

Select top1 * from in SQL Server

ddkdhar

 Profile Answers by ddkdhar Questions by ddkdhar

• Feb 12th, 2007

SELECT * FROM EMPLOYEES WHERE ROWNUM=1; IN ORACLE

Answer Question  Select Best Answer

How to migrate db2 data to notepad?

swaroopbns

 Profile Answers by swaroopbns Questions by swaroopbns

• Apr 30th, 2008

Do you mean that you want to unlaod a db2 table into a notepad or textpad, then you can probably try this:db2> export to yourdirectory/abc.txt of del select * from tablename with ur

Answer Question  Select Best Answer

How to map data from discrete sources like Notepad, MS-Excel, MS-Word to db2

How to load data onto db2 environment other than FTP

Explain how the cursor can become stuck between two items, resulting in a navigation trap.

How can I copy a table from one database instance to another database instance

napster.syed

 Profile Answers by napster.syed Questions by napster.syed

• Feb 27th, 2008

By using Db link

Answer Question  Select Best Answer

What is the difference between Subquery and Corelated Subquery?Give some examples of each

What is Upper and Lower Checkpoint?

amisha_me

 Profile Answers by amisha_me Questions by amisha_me

• Dec 27th, 2007

Only the size differs in nvarchar2 length is much more compare to varchar2

Answer Question  Select Best Answer

sreekumar_nair_it

 Profile Answers by sreekumar_nair_it Questions by sreekumar_nair_it

• Dec 1st, 2007

Try thisCREATE OR REPLACE FUNCTION FIN2008.rowtocol( p_slct IN VARCHAR2,p_dlmtr IN VARCHAR2 DEFAULT ',' ) RETURN VARCHAR2AUTHID CURRENT_USER ASTYPE c_refcur IS REF CURSOR;lc_str VARCHAR2(4000)...

ora.nachs

 Profile Answers by ora.nachs Questions by ora.nachs

• Feb 5th, 2007

we can also do this by insert all statement.....INSERT ALLINTO sales_info VALUES (employee_id,week_id,sales_MON)INTO sales_info VALUES (employee_id,week_id,sales_TUE)INTO sales_info VALUES (employee_i...

Answer Question  Select Best Answer

madhupriya

• Nov 27th, 2007

Normalization is being applied for the database to reduce redundancy as in case of first normal for remove the redundant data from rows and in 2nd normal form it removes the redundant data vertically ...

Answer Question  Select Best Answer

Mohammed Sameer

• Nov 27th, 2007

Dude Remember!when its your first job you should say"It doesnt matter if you pay me less or more i believe with my good work I would get a handsome salary today or tomorrow and I am sure organisation ...

Gururaj

• Nov 30th, 2006

Well,It depends upon your company policies.I liked this figure 10000 so i demanded if ur company wants to pay more u r welcomed.and it depends on year exp.if ur exp then alwaz ask >  30% hike

Answer Question  Select Best Answer

While developing sopping cart application we have to create a main catagory and the admin want facillity that he can add the unlimited number of subcatagories and the subcatagories again having unlimited number of subcatagories. So how to create catagory table to perform this tree like structure

Mohammed Abdul Afroze

• Sep 27th, 2007

If a users is having the SYSDBA Privilege then he can be able to accesses the data dictionary views.

Chiranjeevi Manne

• Mar 30th, 2007

If scott has the privilege of "SELECT ANY DICTIONARY", then he could read the information in DICTIONARY views.

Answer Question  Select Best Answer