|
Question |
Rating |
View Answer |
|
Write a SQL statement to draw the second highest salary in Employee Table (Using Sub query) Table structure is: Employe ID Name Salary |
|
View Answer |
|
How can variables be passed to a SQL routine? |
|
View Answer |
|
What are the tables and structures in database? |
|
View Answer |
|
What is the wildcard character in SQL? |
|
View Answer |
|
In a Client/Server context, what does API (Application Programming Interface) refer to ? |
|
View Answer |
|
What is difference between Oracle and MS Access? What are disadvantages in Oracle and MS Access? What are features & advantages in Oracle and MS Access? |
|
View Answer |
|
Which system table contains information on constraints on all the tables created?
|
|
View Answer |
|
How to find out the database name from SQL*PLUS command prompt?
|
|
View Answer |
|
How to Select last N records from a Table? |
|
View Answer |
|
There are 2 tables, Employee and Department. There are few records in employee table, for which, the department is not assigned. The output of the query should contain all th employees names and their corresponding departments, if the department is assigned otherwise employee names and null value in the place department name. What is the query?
|
|
View Answer |
|
How to find the second highest salary from employee table? and how to write it? |
|
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 |
|
What are the data types allowed in a table? |
|
View Answer |
|
What is SQL Server Agent? |
|
View Answer |
|
What is the difference between @@identity and SCOPE_IDENTITY()? |
|
View Answer |
|
Which TCP/IP port does SQL Server run on? How can it be changed? |
|
View Answer |
|
How to retrieving the data from 11th column to n th column in a table.
|
|
View Answer |
|
When is the use of UPDATE_STATISTICS command? |
|
View Answer |
|
What is the advantage of specifying WITH GRANT OPTION in the GRANT command? |
|
View Answer |
|
How to programmatically find out when the SQL Server service started? |
|
View Answer |