Write sql query for retrieving employee names from employee table who are having salary greater than 5000 without using where clause?
Latest Answer: I Think the question is not well formed.. Please Elaborate ...
Latest Answer: set statistics io onset statistics time on ...
Can we generate a trigger for two tables? if so what is the query to generate a trigger for two tables employee table and department table with employee having department no.
What is the code to create a table having a column named DATE, which takes date in the format dd/mm/yyyy, in SQL Server2000? Or any format of date.
How many column maximum we can add in one table and how many foreign key maximum we can use in one table?
1. Types of Triggers in Oracle 2. Can we relate two different tables from two different users in ORACLE,PL/SQL? 3. How can I combine sequence with select statement which is used in another insert statement. i.e.Insert 4. if records are inserted into table without committing.How to refer to these values in a procedure? 5. when we need to use USING clause in the sql?For example in this below:SELECT emp_name, department_name
Latest Answer: Select Columnname from Tablename Groupby Columnname Having Count*>1 ...
1)What is the maximum value that can be stored for a datetime field? a. Dec 31, 9999 b. Jun 6, 2079 c. Jan 1, 2753 d. Jan 1, 2100 2)What is the correct SQL syntax for returning all the columns from a table named "Persons" sorted REVERSE alphabetically by "FirstName"? a. SELECT * FROM Persons WHERE FirstName ORDER BY FirstName DESC b. SELECT * FROM Persons SORT REVERSE 'FirstName' c. SELECT * FROM Persons ORDER BY -'FirstName' d. SELECT
Latest Answer: SQL*Loader is strictly an ORACLE product. Most of not all vendors provide some kind of utility to load tables from flat files. It's not a question of comparison; you can't use SQL Loader in DB2, neither can you use the DB2 Load Utility in Sybase. ...
View page << Previous 3 4 5 6 [7] 8 9 10 Next >>

Go Top