 Related Questions Can we use aggregate function in another aggregate functionsuppose we got count of a column by using Can we use aggregate function in another aggregate functionsuppose we got count of a column by using the group by clause so we get different counts in the same statement how to get the maximum of count Read Answers (11) | Asked by : sahithi How can i display a column name with a '-' sign. i.e by using concat sttle i can concat two column name but is there a possiblity to display column name as "EMPLOYEE -- ID" Hey there SQL MASTERS, here are some questions i was posed in an interview/assessment thing, dunno how well i did....Coud u answer these questions? i dont know how easy/difficut they are for u, all i know is that i had SERIOUS trouble with them! thanks alot!EMPLOYEEEmployee_id number NOT NULL (Primary Key)Employee_name VarChar(30) NOT NULL Dept_id number NOT NULL (Foreign Key to DEPARTMENT)Manager_id number NOT NULL (Foreign Key to EMPLOYMENT)Salary number Read Answers (7) | Asked by : zen In SQL, I'm analyzing a cluster for a san and I'm not sure if I'm doing it properly. If I ask how many transactions are too many, is there a straight answer? For instance, SQL trace monitored for 5 days, and found 37,405,636 transaction recorded, 0 errors, with 36,346,652 number of stored procedures executed. How does one tell if this is normal or not? View Question | Asked by : Robin 1. why the performance of the table is degraded when more index is created on the table......2. whats the main usage of synonym other than that of creating other names to objects....3. shall we able to create an primary index on the table which already has the null value? if yes syntax please.........4. whats the main usage of trigger.......... (eg..) please... Read Answers (3) | Asked by : karthe Latest Answer : FOR EXAMPLE TO RETRIEVE 2ND COLUMN(ENAME) IN EMP TABLE:SELECT COLUMN_NAME FROM USER_TAB_COLUMNSWHERE TABLE_NAME ='EMP'AND COLUMN_ID = 2 ... Is it possible to insert a new column between two existing columns?for ex:i have a table with two cols:rollno and dateofbirth.suppose if i want a new column named 'name' to be included in between rollno and dateofbirth. is it possible.I know it is possible thro enterprise mgr. how to do using T-SQL Read Answers (4) | Asked by : Krishnan Select comm from emp; The Null column in the output will come in the last i.e at the end. WHY?e.g COMM 1200 1000 1300 1450 ---- (NULL) ---- (NULL) 1. No of User variables in sql*plus is ?2. User can have __ many number of variables per sql command.3. User can have__ many number of lines (assuming 80 characters per line) per sql command.4. The size of PL/SQL buffer in Oracle 7 is 2k and in Oracle6 is 512k oracle 9 is? View Question | Asked by : SHASHIDHAR B.N Latest Answer : SELECT to_char(to_date(24,'J'),'JSP')||' DOLLARS' FROM DUAL ... Read Answers (2) | Asked by : Santosh
Sponsored Links
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
