Query

Question

What is the meaning of Select Ac1_Code Ac1_Name ' ' as Publisher0 as Ac1_Status from accounts1 order by ac1_name

Senthilkumar · Answer

Select Ac1_Code Ac1_Name ' ' as Publisher0 as Ac1_Status from accounts1 order by ac1_name - You are trying to retrieve the result from the account1 table. - You have columns like Ac1_Code Ac1_Name from the table. You want to retrieve the columns - You are trying to retrieve ''(single space empty) in the publisher column in result table. - You are trying to create the Act1_Staus column and you want to make 0 is default result in that column. - You are trying to order the result by ac1_name in the ascending order. Now result will be Ac1_Code Ac1_Name Publisher Ac1_Status 00001 Ajay 0 00002 Babu 0 00003 Harish 0 00004 Ramesh 0 00005 Senthil 0 Hope this will help you to understand this query.a

Prasant Jinaga · Answer

Hi Anil It means fetching Ac1_Code  Ac1_Name  ' ' as Publisher (which is blank values with alias means column name as Publisher ) 0 value with alias or column name Ac1_Status from accounts1 table then ordered by ac1_name Hope it helps!!! Thanks Prasant

Vulpes · Answer

It means from the accounts1 table order all the rows by the ac1_name column and then return the following for each row: 1. The column Ac1_Code 2. The column Ac1_Name 3. A string consisting of a single space given a name of Publisher 4. The integer 0 given a name of Ac1_Status