RomelynCastillo

ahm you can try this one. SELECT * FROM EmployeeSalary a WHERE (2=(SELECT COUNT(Distinct(b.salary)) FROM EmployeeSalary b WHERE b.salary>=a.salary))

If I were you I would create three tables such as REGIONS, LOCATIONS, and PLACES. The REGIONS table contains 1 column named RegList where in all the regions are listed. In the LOCATIONS table there would be two columns named LocList and RegList wherein the LocList contains all the list …

The reason why you can’t insert you input such as “hi what’s up” is because you used a single quote (‘hi what’s up’). Whenever you will use a single quote for your input, you need to use double quote (“hi what’s up”) because if not, the computer will think that …

Hi, we can update view .if the view is created with one table. But we canot update view if the view is created with more than one table with multiple columns.why because view is single virtual table created multiple columns from diffrent tables. so we canot update this virtual table …

Youre using a Sub-query -- [(select dname from dept where deptno = e.deptno)] -- to get around using a join clause like -- [FROM EMP E INNER JOIN DEPT D ON (D.DEPTNO = E.DEPTNO)] -- however, you are not actually getting away with not joining the two tables, youre just …

The .NET Framework consists of two primary parts: the common language runtime, which manages application execution, enforces type safety, and manages memory reclamation, and the .NET base class library, which consists of thousands of pre developed classes that can be used to build applications.

We can store images and videos as well by converting the picture or audio/video into the byte array using C#/ VB and store it in a database as binary file (set the type of the field as binary). because at the end every file is a binary so if you …

Mysql database can be created using php by executing CREATE DATABASE query using mysql_query() function in php

A class library is a set of files containing the source code for classes. These files compile together as a single dll and the classes it contains are available to be shared between several applications.

A database connection can only have one open datareader associated with it at anytime. To do what you are looking to do in your example you must have two connections, one for each datareader.

Hi,Index is used to speed up query.If particular column is used often in queries and table has lot of data.Then it is recommended to create index for that column of the table. It will speed up the query.

A common table expression (CTE) is a temporary named result set that can be used within other statements like SELECT, INSERT, UPDATE, and DELETE. It is not stored as an object and its lifetime is limited to the query.

All .NET compilers produce metadata about the types defined in the modules they produce. This metadata is packaged along with the module (modules in turn are packaged together in assemblies), and can be accessed by a mechanism called reflection.

Visual Basic is a proprietary Programming Language for Win32 API's, basically it can ONLY run on Microsoft products hence Window 95, 98, 98ME, 98SE, Window 2000, XP HE, XP Prof and suits of MS servers and vista. Visual Basic is Microsoft ways of writing application that can run on its …

A data warehouse is a specially setup database designed to hold large amounts of data for reporting purposes. While a normal database is optimized for transactional activity (while keeping a small amount of history) a data warehouse will be optimized for large scale reporting. Data warehouses are designed to help …

CHAR- You specify how many characters you want the field to hold. The maximum value is 255. For example: CHAR(10) This field can then hold a maximum of ten characters. But if you only use 4 of them, the rest of the 10 characters will be blank spaces. The blank …

For a regular MySQL user you can reset the Password with the `SET PASSWORD` command: mysql> SET PASSWORD FOR 'owner' = PASSWORD('secret');

SHOW INDEX FROM table_name;

`net start MySQL` and `net stop MySQL`

Definitely. When you’re in already in the programming or IT industry, you will be doing programs wherein database serves as the backbone. Take for example when you need to do a program for bank operations, you need to have knowledge on how about database and MySQL is one of the …