what is the difference between the null in C and one in SQL?
Latest Answer: Null is a special marker used to indicate that a data value is unknown in the sql. But in case of ‘C’ A "null statement" is a statement containing only a semicolon; it can appear wherever a statement is expected. Nothing happens ...
SenatorSID Name Year Service Party CID1 Jerry 5 Rep 22 Mary 2 Dem 33 Barry 12 Dem 1CountyCID Name Democrats Republicans1 Evergreen 75,000 70,0002 Marsh 12,000 25,0003 Hilltop 9,500 8,000A) List each county in alphabetical order with the senator that serves the county
Latest Answer: the translate function replaces a sequence of characters in a string with another set of characters. However, it replaces a single character at a time. For example, it will replace the 1st character in the string_to_replace with the 1st character ...
Latest Answer: You can use like thisSelect top 10 customer from Databasename..TablenameunionSelect top 10 customer from Databasename..TablenameunionSelect top 10 customer from Databasename..Tablenameex:Select top 10 customer from ABC..abcunionSelect top 10 customer ...
Latest Answer: Pipelined functions are useful if there is a need for a data source other than a table in a select statementFor more details, following link is available.http://www.adp-gmbh.ch/ora/plsql/pipeline.html ...
In table "salary" with emp_no,sal_dt,salary which records salary of all employees every month.find the query to give the amount of salary hike and date of hike for all the employees.
Latest Answer: There are two ways to auto generate the values of a column in a table1) Default value: we can set a default value to column definition2) Identity value: we can set an identity value with initial value and increment value to column definition. ...
Latest Answer: Alter table drop constraint check [name of the constraint] ...
_______data type is used to store binary data such as graphics, sound, etcSQL uses ____________ clause to impose an order on the result of a query _________ function determines the number of rows or column values.The limit that determines the sphere of influence and control over a system is called_______________ is a graphic technique that can be used by analyst to represent the inputs and outputs.
A Table named “Students” which contains studentid, subjectid and marks. Where there are 10 subjects and 50 students. what is the Query to find out the Maximum marks obtained in each subject.
View page << Previous 1 2 [3] 4 5 6 7 8 9 10 Next >>
Go Top
