| Other SQL PLSQL Interview Questions |
|| Asked @
|write a query to remove null following table are
i want the output format like
|what is the cursor and use of cursor in pl/sql ?
|How to return more than one value from a function?
|If we have n no of columns in a table, can we add new
column in that table with not null constraint?
|how to findout the 100th maximum salary
|What is Primary Key?
|Write a query to get last 10 records from the table.
|what is meant by DML?
|What is the difference between SQL and PLSQL
|SELECT emp_num, years, SUM(salary) FROM sales
SELECT emp_id, SUM(takehomepay)
What error is present in the sample code above?
1. Queries being combined with the UNION ALL statement are
not allowed to have SELECT lists with a different number of
2. You are not allowed to use aggregate functions within
two queries joined by a UNION ALL statement.
3. The UNION ALL statement incorrectly combines
the "years" result from the first query with the "SUM
(takehomepay)" result from the second query.
4. Unless the UNION ALL statement is replaced with a UNION
statement, the queries will return duplicates.
5. The "emp_id" column from the second query must be
renamed (or aliased) as "emp_num" so that it corresponds to
the column name from the first query. Otherwise, the
queries will not execute.
|write the Sql query for creating database backup?
|If a View on a single base table is manipulated will the
changes be reflected on the base table?
|For more SQL PLSQL Interview Questions Click Here |