If category_name column is in categories table it will work
"SELECT * FROM categories WHERE category_id NOT IN("SELECT category_id FROM company_categories WHERE company_id=1") ORDER BY...
Type: Posts; User: jaideepu; Keyword(s):
If category_name column is in categories table it will work
"SELECT * FROM categories WHERE category_id NOT IN("SELECT category_id FROM company_categories WHERE company_id=1") ORDER BY...
A composite key has more than one attribute (field). In this example we store details of tracks on albums - we need to use three columns to get a unique key - each album may have more than one disk -...
SELECT TOP 1 *
FROM emp
WHERE ENAME NOT IN (SELECT TOP 1 ENAME FROM emp )
This is in SQL server
SELECT a.empno,a.ename,a.salary FROM
(select empno,ename,row_number() OVER(order by salary desc) rn,salary from emp)a
WHERE rn=1 OR rn = 2
1 select employeeid, empfirstname, emplastname, emphiredate,
2 add_months (emphiredate,6) REVIEW,
3 from employees
4* WHERE MONTHS_BETWEEN (SYSDATE, emphiredate)
Select * from presons order by p_id
now i got the answer
this is the answer
CREATE TABLE sample6
(
col1 int ,
col2 int,
I need while creating the table, it have to effect the data base table
create a table with 3 column where sum of 2 column is 3rd column
ex
col1 col2 col3
1 2 3
3 4 7
2 2 4
List all the job groups who average salary exceeds that of managers.
Empno ename job manager hiredate salary deptno commission
7369 smith clerk 7902 12/1/1982 ...
Thanks pradeep
select ename,role,DATENAME(Day, hiredate)
+ CONVERT(VARCHAR(12), hiredate, 107) as hiredate from emp where deptno = 20
it is showing output like this
smith clerk 1Dec...
how we can do this in sql server 2005
Select top 1 deptname, count(employee) as total from Employee group by deptname order by total.
hear we will get jest top one departname and count of employes but we need higest count of...
List department 20 employee’s jobs and hire dates formatted like “WEDNESDAY January 12, 1983”
how to display this please post the query
thanks,
JaiDeepu
Open QTP
Insert-> step Generator
Category= utility objects (from drop down list)
Object=System util
operation= Run
Arguments
File: value=IEXPLORE.EXE
params: value=www.google.com
For i=1 to 2
Call MyFunction("Hello World")
ExecuteFile "C:\Documents and Settings\jaideepu.namineni\Desktop\Bpt.vbs"
Next
Function MyFunction(text)
MsgBox text
End Function
it will...
Call MyFunction("Hello World")
Function MyFunction(text)
MsgBox text
End Function
ExecuteFile "C:\Documents and Settings\jaideepu\Desktop\hello.vbs"
It will execute the hello.vbs Also
This will use full for u keyword view keyword view sc (click business components in the qc
create the folder by clicking the give the name create the component by clicking on give the name give:-...
The Step Generator dialog box helps you add steps that use test object methods, Utility object methods, and function calls, so that you do not need to memorize syntax or to be proficient in...
If you decide not to associate a function library (any VBScript file) with a test, but do want to be able to call its functions, subroutines, and so forth from an action in your test or from another...
public function FileComparison(in File1, inFile2, out Result)
{
auto SaveFile = "Somefile in which the compared files are saved for future viewing."
Result = file_compare(File1, File2,...