write a querry .if 10 records in a table.i want only 1
record and 3 reocrd and 10 record. how to write a querry.
Answers were Sorted based on User's Feedback
Answer / sreelatha reddy
suppose you have 10 records in a table.First i will explain
about the structure of the table.
emp Table
Sno sname ssal scommm
1 aaa 3000 400
2 bbb 4000 500
3 ccc 5000 500
4 ddd 6000 600
-
-
-
-
-
10 zzz 8000 800
select * from emp where sno in(1,3,10);
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / kishore kumar
select * from table name where rownum in (1,3,10);
Is This Answer Correct ? | 2 Yes | 0 No |
could u tell me from where could i get material for ISTQB foundation level exam..and how can I prepare for that..my mail id ghoshbandana@yahoo.com
What is problem?
what is TRM?
what is the actual time to stop testing a product.
What is the difference between QC 10.0 and ALM 11.5? Whether ALM is any upgradation to QC?
why is waterfall model not good?
What is Application entry and exit criteria
What is white box testing and list the types of white box testing?
Explain metric?
What is test incident report?
What is equivalence partitioning?
Demonstrated system testing experience in a large on-line environment – with at least 2 years experience including Development of test strategies development of test plans • execution of tests according to plans • defect management • using industry tools (eg HP Quality Centre formerly 'Mercury Quality Centre' (Test Director) , and • experience in interrogating and querying SQL server and Mainframe dtabases using tools such as RC Update, BRIO, SQL Server Management Studio