Answer Posted / anil

data abc;
set xyz;
count=1;
length Distance$ 10;
if mails<=50 then Distance='0-50';
else if 50 < mails <= 100 then Distance='51-100';
else if 100<mails <= 150 then Distance='101-150';
run;
proc print;
run;

proc sql;
select Distance,sum(count)as NO_OFCITY
from abc
group by Distance;
quit;

how is myisam table stored? : Sql dba

1099

---

What is an ndf file?

1066

---

What is the best free sql database?

1104

---

what are the different tables present in mysql, which type of table is generated when we are creating a table in the following syntax: create table employee (eno int(2),ename varchar(10)) ? : Sql dba

1080

---

What is the process of copying data from table a to table b?

1137

---

Can you sum a count in sql?

1061

---

How to install oracle sql developer?

1097

---

What does := mean in pl sql?

1091

---

Can we use ddl commands in pl sql?

1235

---

Can there be more than one function with a similar name in a pl/sql block?

1044

---

What is the best sql course?

1028

---

column A column b | output 10 7 | 10 5 8 | 8 7 -9 | 7 3 5 | 5 0 6 | 6 Write a sql query to print such output.

7495

---

Is a foreign key always unique?

984

---

What is plpgsql language?

1142

---

Define concurrency control. : Transact sql

1236

---