|
Related Questions |
View Answer |
|
What are SQL Server 2000 and 2010?
|
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 the tables and structures in database?
|
View Answer
|
|
How can we delete records in a table using update table?
|
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 do we select the employees detail from the table who were joined in the last 5yrs?
|
View Answer
|
|
State some reasons for lack of portability?
|
View Answer
|
|
State about some criticisms of SQL?
|
View Answer
|
|
Explain about Data definition?
|
View Answer
|
|
Explain about COMMIT and ROLLBACK?
|
View Answer
|
|
Explain about the MERGE field?
|
View Answer
|
|
Explain about data retrieval?
|
View Answer
|
|
Explain the where clause?
|
View Answer
|
|
Explain the ORDER BY clause?
|
View Answer
|
|
Explain about predicates and statements?
|
View Answer
|
|
State the several languages into which SQL is divided into?
|
View Answer
|
|
Explain about the information and definition schemas?
|
View Answer
|
|
Explain about XML related specifications?
|
View Answer
|
|
Explain about the object language binding’s extension?
|
View Answer
|
|
Explain about Call level interface present in SQL?
|
View Answer
|