05-02-2020, 05:25 PM
عندك مشكل في التصميم /
على كل في الفايربيرد يمكن بالمثال :
على كل في الفايربيرد يمكن بالمثال :
كود :
/*doctors*/
select * from
(
select first ((select j.doctor from job j
where j.doctor+j.teacher+j.engineer=( select count(*) from student ) ))
s.student_name , 'Doctor' job_name
from student s
order by s.student_test_result desc
)
union all
/*teachers*/
select * from
(
select first ((select j.teacher from job j
where j.doctor+j.teacher+j.engineer=( select count(*) from student ) ))
skip ((select j.doctor from job j
where j.doctor+j.teacher+j.engineer=( select count(*) from student ) ))
s.student_name , 'Teacher' job_name
from student s
order by s.student_test_result desc
)
union all
/*engineers*/
select * from
(
select first ((select j.engineer from job j
where j.doctor+j.teacher+j.engineer=( select count(*) from student ) ))
skip ((select j.doctor+j.teacher from job j
where j.doctor+j.teacher+j.engineer=( select count(*) from student ) ))
s.student_name , 'Engineer' job_name
from student s
order by s.student_test_result desc
)

![[-]](https://delphi4arab.net/forum/D4A2020/collapse.png)