oosrikanth

ok send the program

i need domain aggregate functions to count the occurrences of specific value in a field, and when it exceeds 1, display null. or 'group by' subqueries with count() to see if you should populate the field or not. find the attachment **********************************************************************************

if not in sql, in any other language

<quote>then that is not a SQL question, you'll need to format that in whatever language you're using to display or save the results.</quote>said by other user "question but it seems you want blank rows instead of repeating values. In this case, you just want a list of depts with associated employees, but you don't the dept listed over and over. SQL does not easily support this. You could use domain aggregate functions to count the occurrences of specific value in a field, and when it exceeds 1, display null, but that is quite contrived. You could also use 'group by' subqueries with count() to see if you should populate the field or not. Again - quite contrived and a lot of work." "As a side note, your employee number is open to RI issues. If you change an employees dept, the number would also have to be change. I think that would violate 3rd normal form. Better would be to let the database create an autogenerated number for each employee, and then concatenate that to the dept number as a calculated field." best, any query using reference 1 please post me

select boollen(empid) as boollen (dept no)from table;

link http://4.bp.blogspot.com/-wA9gkuQooMI/T-6RsLBXDFI/AAAAAAAAACU/oUxbP_dsroQ/s320/untitled.JPG

joining register table dno employee table dno result is below two tableregister table dno -- department -- deparment salary101 data processing 50,000102 printing 100,000103 design 250,000 employees 101 101/1 john101 101/2 james101 101/3 abott102 102/1 able102 102/2 adison103 103/1 alien103 103/2 alex103 103/3 alin103 103/4 casper out of above query below i need like below belt register table dno -- department -- deparment salary101 data processing 50,000102 printing 100,000103 design 250,000 employees 101 101/1 john101 101/2 james101 101/3 abott102 102/1 able102 102/2 adison103 103/1 alien103 103/2 alex103 103/3 alin103 103/4 casper out of above query below i need like below belt D NO DEPT D NO E NO E NAME101 data pro 101 101/1 john101 data pro 101 101/2 james101 data pro 101 101/3 abott102 printing 102 102/1 able102 printing 102 102/2 adison103 design 103 103/1 alien103 design 103 103/2 alex103 design 103 103/3 alin103 design 103 103/4 casper In need like this below "boolean" please take 1 min excuseD NO DEPT D NO E NO E NAME101 data pro 101 _______ 101/1 john_____________________101/2 james_____________________101/3 abott102 printing 102 _______ 102/1 able_____________________102/2 adison103 design 103 _______ 103/1 alien_____________________103/2 alex_____________________103/3 alin_____________________103/4 casper

PLS-00302: component 'ALREADY_CAL_CHALK' must be declared in procedure pl/sql

no timestamp or dateobjecti want also timestamp to my table date from now onwards. how to kept

i was uploading table data through toad s/w i need sql query to get last five days. which records is uploaded