these are the columns in the exam_report tableEXAM_CODE,STUDENT_ID,USER_ID,FIRST_NAME,STUDY_CENTER,COURSE,PAPER,APPEARENCEnow i want to know how many student have passed at the end of the yr for each paper?
How to rename a column in a SQL table?
Latest Answer: Basically you dont have an option or a separate syntax for renaming a column in 9i, 10g.But there is one such thing called column alias process can be done initially at the time of querying. ...
How to lock a particular row of a table using SQL?
Latest Answer: INSERT , UPDATE, DELETE operations implicity lock rows of a table that satisfies the condition.Explicitly you may lock a table using for update of as followsSELECT * FROM EMPWHERE EMPNO = 7369FOR UPDATE OF SAL NOWAITIt will lock single row of emp table ...
How to change rows to columns and columns into rows?
Latest Answer: Use decode function. ...
Display deptno wise first three lowest salaries in ascending order of deptno and desc order of salary
display the 5th lowest sal from emp table using Correlated subquery
Latest Answer: display the 5th lowest sal from emp table using Correlated subquerytable have data:----------------SQL> select last_name,salary from employee order by salary asc;LAST_NAME SALARY---------- ----------Cat ...
How to arrange date in week wise like from Monday to Sunday?
Latest Answer: SELECT TO_CHAR(hiredate,'DAY') FROM emp ORDER BY to_char(hiredate-1,'D'); ...
Why do we use aliases during joining two tables?
Latest Answer: Alias name it temporary name given to a tablen or columns of a table.It has its existence until the satement is executed. For example in the following example instead of typing tablenames emp and dept every time you may simply use its ...
How to find all the tables existing in a database?
Latest Answer: To view tables in the current schemaSELECT OBJECT_NAME FROM USER_OBJECTS WHERE OBJECT_TYPE = 'TABLE'To view all the tables that you have access SELECT OBJECT_NAME FROM ALL_OBJECTS WHERE OBJECT_TYPE = 'TABLE'To view all the tables in the ...
What is the difference between sub query and correlated sub query
Latest Answer: In sub query the inner query is executed only once. Depeding upon the results of inner query , outer query is evaluated.In correlated subquery the inner query is evaluated once for each row processed by the parent statement or outer query. ...
View page << Previous 1 2 [3] 4 5 6 7 8 9 10 Next >>
Go Top
