Query

Question

What is the meaning of "Select Ac1_Code, Ac1_Name, ' ' as Publisher,0 as Ac1_Status from accounts1 order by ac1_name "

Senthilkumar · Answer

Select Ac1_Code, Ac1_Name, ' ' as Publisher,0 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

Query

Answers (3)