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 |
What are the native operators of Datastage? (ETL Tool)
Please send me the materials for ISTQB certification. My email ID is testdir@yahoo.com. Thanks in advance. Am specifically looking for The book: Sample Exam Questions: ISTQB Certified Tester Foundation Level (Paperback) by PhD, CTFL John A. Estrella (Author), BSc, CTFL Maria C.Estrella (Author) ISBN-13: 978-1425131333
Write a function Occurrences() in a language of your choice that takes in two strings. The first is a search string, and the second is a sentence. For example, running the function: Running Occurrences ("o", "Red Gate Software - Ingeniously Simple Tools") will output: Occurrences of 'o': 4 Occurrences ("at", "The cat sat on the mat") will output: Occurrences of 'at': 3 Sample Question 2: 2)Below is Notepad's File/Save dialog. a) If you were asked to test this dialog, how would you go about it? b) List various inputs you might place into the "File name" text field to test it.
What are the main key components in Web applications and client and Server applications? (differences)
4 Answers Accenture, Disha Tech, Verisoft,
Hi, For the web application testing, whether we can use "Acunetix Web Vulnerability Scanner", I want to know in detail. Thanks in advance bye
What is pdr - peer design review?
hi,iam learning testing tools in mindq.i want to put 2+exp. is there any problem with that. tell me what are the Interview questions for experienced peopole. please give me the answer. thanq
What is the difference between functional test type and navigation test type?
What is the meaning and purpose of each of: 1) Test Strategy 2) Test Plan #) Test Case? What is an example of each?
Mention what the meaning of breath testing is?
hey, i recently attended 2 interviews and they asked whether I used qamonitor of softsmith. any help on what it does?
Explain cause-effect graphing?