|
Question |
Rating |
View Answer |
|
State some reasons for lack of portability? |
|
View Answer |
|
How do we select the employees detail from the table who were joined in the last 5yrs? |
|
View Answer |
|
Table1
Date Inv No. Sr.No.
01/04/2009 1 1 01/04/2009 2 2 0304/2009 3 1 04/04/2009 4 1 04/4/2009 5 2
table2 01/04/2009 1 1 01/04/2009 1 1 01/04/2009 1 1 01/04/2009 2 2 01/04/2009 2 2 01/04/2009 2 2 0304/2009 3 1 04/04/2009 4 1 04/04/2009 4 1 04/4/2009 5 2
I want sql query or PL/SQL Block to update the Sr.No. field automatically as shown in the above tables. Sr.No is not entered Manually. This sr.No. should be updated by selecting the date range i.e. from date and two date. |
|
View Answer |
|
How can we delete records in a table using update table?
|
|
View Answer |
|
What are the tables and structures in database? |
|
View Answer |
|
Can we connect two different relational tables from different data sources and get the output as one flat file? |
|
View Answer |
|
What are SQL Server 2000 and 2010? |
|
View Answer |
|
What is the difference between "select * from table name" and "select column_name from table name" The above quiries are simple select quiries without having any "where" clause. Secondly which query will be performed faster and why?? |
|
View Answer |
|
given a table of student(rollno,name,dno,dateofadmission,city) and department(dno,dname)...How u will found the rollno,class,deptname of students in ascending order of their departments? |
|
View Answer |
|
Identify error in following SQL: SELECT EMPNO, SUM(SAL) FROM EMP GROUP BY EMPNO HAVING ENAME= ‘KENT’ a) Syntax Error b) SUM() is not an aggregate function c) HAVING can not be used with GROUP BY d) The Having condition has to be based on some column that appears in the select list. |
|
View Answer |
|
How to get short name & long name of the month or month of given date
|
|
View Answer |
|
What are the types of join and explain each ? |
|
View Answer |
|
What are the types of subquery? |
|
View Answer |
|
What is Union, minus and Interact commands? |
|
View Answer |
|
How can you create an empty table from an existing table? |
|
View Answer |
|
What is the command used to fetch first 5 characters of the string? |
|
View Answer |
|
What are the different index configurations a table can have? |
|
View Answer |
|
What is difference between DELETE and TRUNCATE commands ? |
|
View Answer |
|
What are the properties and different Types of Sub-Queries? |
|
View Answer |
|
What is SQL Profiler? |
|
View Answer |