Search results for sql


Both primary key and unique enforce uniqueness of the column on which they are defined. But by default primary key creates a clustered index on the co ...
Having clause is used only with group functions whereas Where is not used with.

[Source: JAGAN MOHAN "Interview questions bible"]
Blob and Clob.

[Source: JAGAN MOHAN "Interview questions bible"]
Dropping : (Table structure + Data are deleted), Invalidates the dependent objects ,Drops the indexes Truncating: (Data alone deleted), Performs a ...
The GROUP BY keywords have been added to SQL because aggregate functions (like SUM) return the aggregate of all column values every time they are call ...
You could use the COUNT keyword , example SELECT COUNT(*) FROM emp WHERE age>40 [Source: JAGAN MOHAN "Interview questions bible"] ...
You can sort the results and return the sorted results to your program by using ORDER BY keyword thus saving you the pain of carrying out the sorting ...
The SELECT statement in conjunction with DISTINCT lets you select a set of distinct values from a table in a database. The values selected from the da ...